Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

replace character

razzy
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 

3 REPLIES 3
kat
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

DavidP
16 - Nebula
16 - Nebula

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

 

replace word in string.png

tom_montpool
12 - Quasar

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