replace character

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

Preparation

Accepted answers

tom_montpool

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.

All comments

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

replace example.yxmd

DavidP

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

replace word in string.png

tom_montpool

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703