Replace every second instance of a comma with an underscore

[bman213]

Hi all,

I am trying to replace every second instance of a comma in a single row with an underscore. So:

Nov 17, 2020,Nov 19, 2020,Nov 6, 2020,Nov 13, 2020

With:

Nov 17, 2020_Nov 19, 2020_Nov 6, 2020_Nov 13, 2020

The objective is so I can then parse the different dates to separate columns by splitting at the underscore.

Thank you in advance for the help!

[apathetichell]

regex/tokenize extract the dates. edited with a version with datetimeparse to turn into alteryx dates.

[Qiu · Accepted solution]

@bman213 
I dont know how to replace the every 2nd one, but we can replace the one after 4 digits of Year/

[bman213]

Thank you!