Parsing Multiple Dates from a freeform text field
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Parse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@gabrielvilella , thanks for sorting this out! The workflow you did is exactly doing what I was trying to do! Worked perfectly!
