I'm trying to work out how to replace a word in my website script that I run on a file import to clean up the data.
In my example I want to replace the Subcategory called "Seeds" to now be called "Plants & Seeds"
At the moment it looks like this:
[str_replace('Seeds','Plants & Seeds',{subcategory[1]})]
But that will also replace other Sub categories that also have the word "Seeds"
I have tried the following both without success( basically wild guessing):
[str_replace(':Seeds', '"Plants & Seeds"',{subcategory[1]})]
[str_replace($Seeds, "Plants & Seeds",{subcategory[1]})]
This must be on one line to work in my field with the import script on the website.
How could I do this?