gianluigi-icit
commented
4 years ago hello!
I double checked few things, the problem is how the regex is crafted, here a working example
php srdb.cli.php -u dbuser -p dbpass -n banana -s '/.*<p class="zoundry_bw_tags">(.*?)<\\\/p>.*/' -r '$1' -h standfirst-mariadb --regex trueBefore
<p>Here is my blog post content</p> <p class="zoundry_bw_tags"> <!-- Tag links generated by Zoundry Blog Writer. Do not manually edit. https://www.zoundry.com --> <span class="ztags"><span class="ztagspace">Technorati</span> : <a href="https://technorati.com/tag/branch" class="ztag" rel="tag">branch</a> </span> <br /> <span class="ztags"><span class="ztagspace">Del.icio.us</span> : <a href="https://del.icio.us/tag/branch" class="ztag" rel="tag">branch</a></span> <br /> <span class="ztags"><span class="ztagspace">Ice Rocket</span> : <a href="https://www.icerocket.com/search?tab=blog&fr=h&q=branch" class="ztag" rel="tag">branch</a></span> </p>After
<!-- Tag links generated by Zoundry Blog Writer. Do not manually edit. https://www.zoundry.com --> <span class="ztags"><span class="ztagspace">Technorati</span> : <a href="https://technorati.com/tag/branch" class="ztag" rel="tag">branch</a> </span> <br /> <span class="ztags"><span class="ztagspace">Del.icio.us</span> : <a href="https://del.icio.us/tag/branch" class="ztag" rel="tag">branch</a></span> <br /> <span class="ztags"><span class="ztagspace">Ice Rocket</span> : <a href="https://www.icerocket.com/search?tab=blog&fr=h&q=branch" class="ztag" rel="tag">branch</a></span> 
dleigh
First of all let me express my gratitude for an amazing tool that simply outshines all the competing tools! Thank you!
Secondly, I'd love to see some specific info with respect the regex implementation (given the huge number of dialects out there and the extra flags - I'm guessing it's PCRE PHP, but I've seen references to JavaScript as well). Anyway, just knowing a bit more about what it's trying to do under the covers would help in creating the regex string.
My issue: I have some posts in WordPress that have a consistently formatted tag area at the end of each post that I want to get rid of. I have the beginning paragraph with a unique class to start with and the end paragraph tag to end with and it's at the end of the post. I "find" the whole post and then use backreferences to try and replace it with only the beginning of the post, discarding the tags section.
It seems to "find" the posts correctly, but when I preview the changes in a dry run, nothing has changed. My posts are long, but let me mock up a post and show you what I'm looking for and what I'm getting:
Initial post:
<p>Here is my blog post content</p> <p class="zoundry_bw_tags"> <!-- Tag links generated by Zoundry Blog Writer. Do not manually edit. https://www.zoundry.com --> <span class="ztags"><span class="ztagspace">Technorati</span> : <a href="https://technorati.com/tag/branch" class="ztag" rel="tag">branch</a> </span> <br /> <span class="ztags"><span class="ztagspace">Del.icio.us</span> : <a href="https://del.icio.us/tag/branch" class="ztag" rel="tag">branch</a></span> <br /> <span class="ztags"><span class="ztagspace">Ice Rocket</span> : <a href="https://www.icerocket.com/search?tab=blog&fr=h&q=branch" class="ztag" rel="tag">branch</a></span> </p>What I want to see after replacing is:
<p>Here is my blog post content</p>Instead, what I'm seeing is just the whole post again - no changes shown in the preview.
My regex string is:
(.*?)<p class="zoundry_bw_tags">(.*?)<\/p>(.*?)My backreference string is:
$1You can see that it works here:
https://regex101.com/r/ZnWRW5/1
If I'm doing something wrong, please let me know. Otherwise, is this a bug? Thanks!