Remove comma from number in text field

Question

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!

Emil_Kos · Accepted Answer

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:

JosephSerpis · Accepted Answer

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], ",", "").