XF 2.1 Left with lots of '

[knobby]

Going through some of my posts now my forum is set up, I am finding lots of instances of ' and various other spurious characters. I'm sure I saw something on here which would allow the removal/replacement of these types of thing. Can someone point me in the right direction please?
Thanks

 

[Paul B]

There is this add-on: https://xenforo.com/community/resources/post-content-find-replace.5748/

For simple replacements of that nature though, you can use direct queries.

UPDATE xf_post SET message = REPLACE(message, 'original_content', 'new_content');

Make sure you craft the queries very carefully to ensure you don't replace any text erroneously.

Take a backup of the database before you start.

 

[knobby]

I've installed the plugin, but can you tell me what this does & mean please?:

"Enter a full, valid PCRE regular expression."
Thanks

 

[Yodrak]

"Enter a full, valid PCRE regular expression."

In this Discussion you'll find a lot of examples for how to use regex.

Post Content Find / Replace

Kier submitted a new resource: Post Content Find / Replace (version 1.0.0) - Allows an administrator to do a regular expression find and replace in the content of all posts. This is a very simple add-on I put together in order to allow an administrator to do a regular expression find and...

xenforo.com