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!
Solved! Go to Solution.
@bman213
I dont know how to replace the every 2nd one, but we can replace the one after 4 digits of Year/
Thank you!