We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Parsing Multiple Dates from a freeform text field

melissa_m
8 - Asteroid

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

4 REPLIES 4
gabrielvilella
14 - Magnetar

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

gabrielvilella_1-1645154640694.png

 

melissa_m
8 - Asteroid

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
14 - Magnetar

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

melissa_m
8 - Asteroid

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

Labels