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....
Solved! Go to Solution.
Do all the rows have the same structure ? Is this comma always the fifth ?
Yes....
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
@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.