Challenge #4: Date Parsing
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jamielaird
14 - Magnetar
08-20-2017
07:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's my solution.
Spoiler
1) I started off by adding a record ID, isolating the part of the string containing the date and removing redundant characters:

2) I then used a formula tool to create three streams corresponding to the different date formats, first using Regex to test if the first character was a digit, which enabled me to identify the [Mon dd yyyy] strings, and for those where this was not the case using FindString to check if the last four characters contained a hype, which enabled me to identify [dd-Mon-yyyy] and [dd-Mon-yy]. These streams then fed into an appropriately configured DateTime tool.

2) I then used a formula tool to create three streams corresponding to the different date formats, first using Regex to test if the first character was a digit, which enabled me to identify the [Mon dd yyyy] strings, and for those where this was not the case using FindString to check if the last four characters contained a hype, which enabled me to identify [dd-Mon-yyyy] and [dd-Mon-yy]. These streams then fed into an appropriately configured DateTime tool.
3) Finally a bit of column cleaning and joined back to the original dataset using the record ID.
KayT
5 - Atom
08-22-2017
10:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A_Twa
8 - Asteroid
08-23-2017
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Lorna_Eden
7 - Meteor
08-23-2017
08:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Natasha
10 - Fireball
08-26-2017
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JacobR77
8 - Asteroid
09-06-2017
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ACE Emeritus
09-09-2017
01:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As others have said this is a great exercise for working on improving your regex skills.
Here's my solution.
Ben
MaxGiegerich
8 - Asteroid
09-15-2017
01:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
09-15-2017
04:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
I used a regex tool and then the BB-Date macro. It caught 3 of the 4, so I just added a comma (Jun 5 2000 >>> Jun 5, 2000) so that way BB-Date handled all of the dates.

Suzanne
7 - Meteor
09-28-2017
05:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator