replace character
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could simply do it like this (unless I'm not understanding you correctly):
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
