RegEx formula help

[Brad1]

What is the RegEx formula to fix this?

abc,,,test,,something,,,,blah

s/b

abc,test,something,blah

Need to remove extra commas where ever two or more show up together.

[Jonathan-Sherman · Accepted solution]

Hi @Brad1,

You will be able to use REGEX_Replace([ColumnName], ',+', ',')  in a formula tool

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[fmvizcaino · Accepted solution]

Hi @Brad1 ,

You need to use the replace method of regex and the following regex expression.

,+

Let me know if that works for you.

Best,

Fernando V.

[Brad1]

Thanks,

With this formula:  REGEX_Replace([test], ',{1,}', ',')  

I will rule the world.