How to replace a word or characters with another word in a column?
- 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
I tried using a filter for this to replace all rows that have 3001 to be changed to 1380. Is there a different way to get this to work? Thank you all
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @maddoxs,
You have one to many brackets at the end the formula should be:
Any questions or issues please ask
Ira Watt
Technical Consultant
Watt@Bulien.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try placing a "tostring" in front : Replace(tostring([number]),'3001', '1380')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Once I close the bracket at the end it stops showing colors.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The issue is that replace function only works on text data not numeric. Your data most likely comes in as a integer (number data type):
You can convert it to a string/text data type with a select tool:
Or you can use the two string method as @Watermark suggested.
The community has some quick and easy videos on formulas and the Formula Tool here Writing Expressions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you want to leave it as a number, you could also go with an "If Then" statement
if [number]=3001
then 1380
else [number]
Endif
However this will only change that 1 number, so if it's just a replace that 1 then cool, otherwise you'll have to expand to take other options into account.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great point @Watermark 😅 !
