String Manipulation

Hello,

I am normalizing data using the String Manipulation Node. I am using the replace function as follows:  replace(§COLUMN§,"WORDS TO SEARCH","WORDS TO REPLACE") but when the function does the search, it replaces with "WORDS TO REPLACE" in any row containing ANY WORD from the expression "WORDS TO SEARCH". So I get results like:

"WORDS TO REPLACE TO SEARCH"

Someone knows how to fix this?

 

 

Hi,

could you make me an examplary workflow? I couldn't reproduce the problem...

Thanks! Iris