Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

RegEx formula help

Highlighted
11 - Bolide

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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Brad1 ,

 

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

,+

 

 

fmvizcaino_0-1574191269307.png

 

Let me know if that works for you.

Best,

Fernando V.

Highlighted
11 - Bolide

Thanks,

 

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

 

I will rule the world.

Labels