Replace every second instance of a comma with an underscore

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!

Regex

Accepted answers

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

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

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

Thank you!