Challenge #4: Date Parsing

[alexo]

That was hard - I managed to use three separate regex tools to match all the dates, then joined them based on most specific match to least specific

[RotesDB]

Spoiler

[RWvanLeeuwen]

Shout out to @markp201 for his RegEx solution for which I had to learn RegEx first in order to understand the meaning of it 😄

Spoiler

[Rant]

Solution Attached. Regex makes this a lot easier!

Spoiler

Spoiler

[KMcKean]

Spoiler

Fun!  With only four date formats, it seemed simpler to just filter and parse each format separately than to convert them.

[acastelazo]

Learned a lot about regular expressions:

Spoiler

(0?[1-9]|[12][0-9]|3[01]|JAN|FEB|MAR|MAY|APR|JUL|JUN|AUG|OCT|SEP|NOV|DEC)

[- /.]

(JAN|FEB|MAR|MAY|APR|JUL|JUN|AUG|OCT|SEP|NOV|DEC|JULY|0?[1-9]|[12][0-9]|3[01])

[- /.,]

(18\d\d| ?19\d\d|20\d\d|\d\d)

[Marcel_Gavrila]

Here's my solution!

Spoiler

[brandowd]

Hi All - here's my solution. It somewhat lacks the same level of detail as the solution but works quite nicely. This one I loved doing as very typical of things I've had to clean up at work. 

[garrettlem1017]

Used Regular Expression tool and DateTime Tool to extract dates and convert from strings.

[piotrzawistowski]

My version.