Remove comma from number in text field
- 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 there,
I have an address that I want only to remove the comma from, but I want to keep the other commas in place. The address is as follows:
700, 5075 Falconridge Blvd NE, Calgary, AB T3J 4L8, Canada
I need to only remove the comma after the 700, but keep the others. Any help would be appreciated!
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @b86,
I have an amazing tip for you. There is a formula that can help you:
ReplaceFirst([Adress], ',', '')
It will replace the first string with something else. In this particular case, we just remove it.
The output:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @b86 if your data is consistent and the first comma is what you always want to remove you can try the ReplaceFirst fucntion. The Syntax in a formula tool would be ReplaceFirst([Address_Field], ",", "").
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!
