Parsing Multiple Dates from a freeform text field

[melissa_m]

Hello Alteryx Community,

I have this column that can potentially contain any combination of the following.  I am needing to parse this text field into separate date columns. Text to Columns doesn't work since the delimiter can vary.  I was thinking perhaps Regex Parse can handle this but not quite sure of the syntax that can manage the different scenarios below.  Appreciate any guidance. Thanks!

July 1, 2025
May 30, 2019 and May 30, 2027
July 31, 2023, July 31, 2031
December 10, 2023, and December 10, 2031
December 10, 2023 and then December 10, 2031
December 10, 2023, then December 10, 2031
November 26, 2023 & November 26, 2031
August 4, 2022 and 2030
January 1, 2022, January 1, 2030 and January 1, 2038
January 1, 2022, January 1, 2030 , January 1, 2038
August 29, 2016, August 29, 2024 and then August 29, 2032
September 17, 2020, September 17, 2028, and September 17, 2036
November 30, 2017, November 30, 2025, November 30, 2033, and November 30, 2041

[gabrielvilella]

Hi @melissa_m, here is one way of doing this :) 

[melissa_m]

Hi @gabrielvilella ,

Thanks so much for the quick workflow !!!! It worked for majority of the format.  One format it couldn't handle is if the input comes in as follows:

1. August 4, 2022 and 2030

2. August 4, 2022, 2030 and 2038

3. August 4, 2022, 2030, 2038

The initial parsing required should look like this before it can work with the workflow you provided.... 

1. August 4, 2022 and August 4, 2030 

2. August 4, 2022, August 4, 2030 and August 4, 2038

3. August 4, 2022, August 4, 2030, August 4, 2038

[gabrielvilella · Accepted solution]

Now that was a challenge, but a fun one! Here is how I did it.

[melissa_m]

@gabrielvilella , thanks for sorting this out!  The workflow you did is exactly doing what I was trying to do! Worked perfectly!