Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

replace character

8 - Asteroid

Hi All, 

I am having a problem figuring out what tool to use in replacing a word or group of words on a column with another word.

I am not sure i may be doing the right thing. I am trying to use a formula tool to output the required word. For example: I a have a column with words "definite(no other)", "definite", "probable/Possible". What i want is just to replace the any word that is "definite" with "DEFINITE" or "probable/Possible" with "POSSIBLE".

Thanks for helping 

12 - Quasar

Hi @razzy


If you have a list of options, then the attached with the find/replace tool should do the trick.


Otherwise the formula 'replace' might be what you're looking for.


Let me know if you need more help.


15 - Aurora

You could simply do it like this (unless I'm not understanding you correctly):


replace word in string.png

ACE Emeritus
ACE Emeritus

The Find/Replace tool is a great option, particularly if there are a lot of alternatives, just be careful how you set some of the options like "Case Insensitive Find".


The Replace() formula function is also great -- and they can be nested:




But nesting can get messy if there are a lot of alternatives.