Searchand Replace text in Drupal Nodes I client has recently been acquired by a new Group and has requested that I do a search and replace for their name e.g. "Foo Group" and replace this with "New Group". There will be multiple instances of this e.g. "Foo Housing Trust Group" and "Foo Housing Trust".

I can see in a previous post How to fix millions of alt text that are missing on body content that I can use the Search and Replace Scanner module but would this be the best way to do this rather than a DB Query?

Thank you for any help you can provide. Pete.
A possible alternative to achieve what you're trying to do, is to use a combination of these (commonly used) modules: Rules, Views and VBO.

With these modules in place, you could implement (for each of the fields that your question is related to) a variation of the solution described in my answer to "How to bulk update select list fields?", i.e.:


Create a Rules Component with a Rules Condition to checks if the field contains the string you're interested in (probably using a "text comparison" with a "regular expression" to find all variations).
Create a VBO enabled view of all nodes to be checked, whereas you'll use the Rules Component as your custom VBO action.


Repeat the above for each field (simply by adapting your Rules Component for each of these fields).

PS: I'm assuming this question is above D7 ...

Done ...