CB Replacer Bot - syntax
- micheleq
- OFFLINE
-
Elite Member
- Posts: 191
- Thanks: 22
- Karma: 5
2 months 1 week ago #337239
by micheleq
CB Replacer Bot - syntax was created by micheleq
Hello,
I'm having trouble figuring out the syntax for my replacement.
The goal is to insert Wikipedia links at the bottom of articles. I've been given a spreadsheet with different entries for each article (hundreds, close to 1000 entries.)
My idea is to enter them as an expression to be replaced e.g.And generate the output:
From the spreadsheet, I can enter them through a query to the appropriate article, that's not a problem.
I'm failing on creating the replacer code.
I'm using PHP to split the expressions using the commas (,) and create the output, which works fine as PHP but I can't get it to work in the replacer
In the 'From' box I've tried (with REGEXP and Code (PHP) on) :And the PHP code that works is:
How can I get this to work?
Thank you!
Tomás
I'm having trouble figuring out the syntax for my replacement.
The goal is to insert Wikipedia links at the bottom of articles. I've been given a spreadsheet with different entries for each article (hundreds, close to 1000 entries.)
My idea is to enter them as an expression to be replaced e.g.
{wp = The Beatles, Liverpool, John Lennon, Paul McCartney, George Harrison, Ringo Starr}<ul>
<li><a href="https://en.wikipedia.org/wiki/The Beatles" target="_blank">The Beatles</a></li>
<li><a href="https://en.wikipedia.org/wiki/Liverpool" target="_blank">Liverpool</a></li>
<li><a href="https://en.wikipedia.org/wiki/John Lennon" target="_blank">John Lennon</a></li>
<li><a href="https://en.wikipedia.org/wiki/Paul McCartney" target="_blank">Paul McCartney</a></li>
<li><a href="https://en.wikipedia.org/wiki/George Harrison" target="_blank">George Harrison</a></li>
<li><a href="https://en.wikipedia.org/wiki/Ringo Starr" target="_blank">Ringo Starr</a></li>
</ul>From the spreadsheet, I can enter them through a query to the appropriate article, that's not a problem.
I'm failing on creating the replacer code.
I'm using PHP to split the expressions using the commas (,) and create the output, which works fine as PHP but I can't get it to work in the replacer
In the 'From' box I've tried (with REGEXP and Code (PHP) on) :
/\{wp =(.+)\}/<?php
$keywords = preg_split("/[,]+/", $1);
$textoutput = "<ul>";
foreach ($keywords as $link) {
$link = ltrim($link);
$textoutput .= "<li><a href='https://en.wikipedia.org/wiki/" . $link . "' target=_blank >" . $link . "</a></li>";
}
$textoutput .= "</ul>";
echo $textoutput;
?>How can I get this to work?
Thank you!
Tomás
Please Log in to join the conversation.
- micheleq
- OFFLINE
-
Elite Member
- Posts: 191
- Thanks: 22
- Karma: 5
2 months 1 week ago #337241
by micheleq
Replied by micheleq on topic CB Replacer Bot - syntax
As an update, this is where I'm stuck.
I have in the "From" boxIn the "To" boxMy output is:
But if I replace
with
Then I do get what I'm looking for, which is:
It seems I can't process the string to an array from the regexp string ($1) but if I use that exact text (forced) as the string, it delivers fine.
I have in the "From" box
/\{wp =(.+)\}/$wiki = '$1';
$textoutput = "<ul>";
$keywords = preg_split("/[,]+/", $wiki);
foreach ($keywords as $link) {
$link = ltrim($link);
$textoutput .= "<li><a href='https://en.wikipedia.org/wiki/" . $link . "' target=_blank >" . $link . "</a></li>";
}
$textoutput .= "</ul>";
echo $textoutput;<ul>
<li><a href="https://en.wikipedia.org/wiki/ The Beatles, Liverpool, John Lennon, Paul McCartney, George Harrison, Ringo Starr" target="_blank"> The Beatles, Liverpool, John Lennon, Paul McCartney, George Harrison, Ringo Starr</a></li>
</ul>But if I replace
$wiki = '$1';with
$wiki = ' The Beatles, Liverpool, John Lennon, Paul McCartney, George Harrison, Ringo Starr';Then I do get what I'm looking for, which is:
<ul>
<li><a href="https://en.wikipedia.org/wiki/The Beatles" target="_blank">The Beatles</a></li>
<li><a href="https://en.wikipedia.org/wiki/Liverpool" target="_blank">Liverpool</a></li>
<li><a href="https://en.wikipedia.org/wiki/John Lennon" target="_blank">John Lennon</a></li>
<li><a href="https://en.wikipedia.org/wiki/Paul McCartney" target="_blank">Paul McCartney</a></li>
<li><a href="https://en.wikipedia.org/wiki/George Harrison" target="_blank">George Harrison</a></li>
<li><a href="https://en.wikipedia.org/wiki/Ringo Starr" target="_blank">Ringo Starr</a></li>
</ul>It seems I can't process the string to an array from the regexp string ($1) but if I use that exact text (forced) as the string, it delivers fine.
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68528
- Thanks: 9093
- Karma: 1434
2 months 1 week ago #337245
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic CB Replacer Bot - syntax
CB Replacer Bot is just using preg_replace when "Is REGEXP" is set to "Yes". That's basically it. From is the $pattern, To is the $replacement, and the article is the $subject. So for that usage you'd need to keep that in mind.
When "Process "To" Code (PHP)" is set to "Yes" to runs "To" through PHP processing and expects it to be PHP. This is done before it does the replacement. So if "Is REGEXP" is "Yes" then the result of your PHP is passed as the $replacement for the preg_replace.
Your PHP code has access to the following variables: $context, $content, $input
$content is the the article object in the case of using this inside of a Joomla article. To get the article contents you'd use $content->text and perform whatever PHP you need on it. In short "From" just becomes a matcher and your PHP is entirely responsible for parsing the text and returning whatever you're wanting it to return.
When "Process "To" Code (PHP)" is set to "Yes" to runs "To" through PHP processing and expects it to be PHP. This is done before it does the replacement. So if "Is REGEXP" is "Yes" then the result of your PHP is passed as the $replacement for the preg_replace.
Your PHP code has access to the following variables: $context, $content, $input
$content is the the article object in the case of using this inside of a Joomla article. To get the article contents you'd use $content->text and perform whatever PHP you need on it. In short "From" just becomes a matcher and your PHP is entirely responsible for parsing the text and returning whatever you're wanting it to return.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
The following user(s) said Thank You: micheleq
Please Log in to join the conversation.
- micheleq
- OFFLINE
-
Elite Member
- Posts: 191
- Thanks: 22
- Karma: 5
2 months 1 week ago #337262
by micheleq
Replied by micheleq on topic CB Replacer Bot - syntax
Hi Kyle,
Thanks for the detailed clarification. I understand now that the PHP code is processed BEFORE the replacement. That was why I couldn't get it to work.
I got it to work with PHP getting the article text ($content->text), processing it and then the replacement worked perfectly.
Thank you,
Tomás
Thanks for the detailed clarification. I understand now that the PHP code is processed BEFORE the replacement. That was why I couldn't get it to work.
I got it to work with PHP getting the article text ($content->text), processing it and then the replacement worked perfectly.
Thank you,
Tomás
The following user(s) said Thank You: krileon
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.412 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- CB Replacer Bot - syntax