RegEx Replace

[DrewL]

Hello!

I have some data that I need to add commas between, see below example.

abcdef I need formatted as a,b,c,d,e,f.

I currently have REGEX_Replace([Text], "", ',') where it gives me ,a,b,c,d,e,f,. I then have a separate formula to remove the front comma, REGEX_Replace([Output], "^(\W)", '') and third to remove the end comma, REGEX_Replace([Output], "(\W)$", ''). I can "nest" these together (REGEX_Replace(REGEX_Replace(REGEX_Replace([Text], "", ','), "^(\W)", ''), "(\W)$", '')) and it gives me what I need, but strictly for learning purposes, I am wondering if there is a more efficient way to do this.

Thanks in advance!

[CharlieS · Accepted solution]

Hi @DrewL 

One alternative to consider is using a RegEx tool to split the characters into rows, then a Summarize tool to concatenate them back together with commas between.

Check out the attached workflow for an example. 

[danilang · Accepted solution]

Hi @DrewL 

A slightly simpler option would be this

Trim(REGEX_Replace([Field1], "(.)", "$1,"),",")

Dan

[DrewL]

Thank you!