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.
SOLVED

replace character

Highlighted
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 

Highlighted
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.

Kat

Highlighted
15 - Aurora

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

 

replace word in string.png

Highlighted
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:

 

Replace(Replace([Field],"Definite","DEFINITE"),"probable/Possible","POSSIBLE")

 

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

Labels