Parsing Out Last Date when dates are entered in different formats
- 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
Trying to parse out the last date for each contact but the dates are all listed in inconsistent ways. Any suggestions using RegEx?
Contact | Date |
AA | 18 March, 2020 27 March 3 April |
BB | 3/30/2020 |
CC | 3/23/2020 4/6/2020 |
DD | 3/18/20 & 3/23/20 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can split the rows off to different streams with filter tools when you have an & between the dates, a comma in the dates, a space between them, etc. Then these dates can be split on the delimiter. However, I am not sure about how to handle rows like the first one where you have multiple formats in the same cell.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @michsherm, what would be the year for dates mentioned in first row (contact AA)? Broadly, I would parse out the individual dates into multiple rows to structure the data into unique key value pairs of Contact and Date, convert date string into standard Alteryx date format, finally filtering out the last date.
Attached is an implementation of the approach. Hope this helps.