Removing comma between two words

[Raj008]

Hi All,

In a field "5000,999,BUS Stop,,BUS, Stop%", I need to remove comma after the BUS

How to go about?

Thanks in advance...

Raj....

[Jean-Balteryx]

Do all the rows have the same structure ? Is this comma always the fifth ?

[Raj008]

Yes....

[Jonny · Accepted solution]

Hi @Raj008 ,

there are many ways to go about this, depending on if there is a pattern on the data etc.

a simple approach would be using a formula tool to replace 'BUS,' with 'BUS'

syntax: 

Replace([  Field1   ], 'BUS,', 'BUS')

hope it helps!

cheers!

Jonny

[Jean-Balteryx · Accepted solution]

@Raj008 , you can use the following formula in a Formula tool :

REGEX_Replace([Field1], "(.*),(.*)", "$1$2")

It replaces the last comma whatever is before and after.