replace character

[razzy]

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 

[kat]

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]

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

[tom_montpool · Accepted solution]

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.