Remove comma from number in text field

[b86]

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 solution]

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 solution]

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

[b86]

Thank you!