Contains Function Not Acting as Expected

[johnnyt]

Hi,

I am trying to use the "Contains" formula below with an If statement to replace strings of text containing the word "OPERATOR".

If Contains([speech_txt], "OPERATOR",1) then [speech_txt] = "OPERATOR" else [speech_txt] endif

But the text highlighted below doesn't change. Any idea whats happening?

[TheOC · Accepted solution]

hey @johnnyt!

Its to do with your "[speech_txt] = "OPERATOR"" This wants to just be changed to "OPERATOR". I have attached a workflow showing it working:

[johnnyt]

Thanks, I knew it was something simple!

[TheOC]

not a problem! Glad i could help, hope you've got a great week ahead 🙂