Challenge #4: Date Parsing

[jestinejoseph]

Parsing the field was difficult however, completed using just three tools. Regex, Formula and Select. Took some to time to get the correct output.

[AmandaH]

This was a fun challenge! I used regex to parse the two date variations from the strings, and then DateTime tools to parse the date formats and a formula to coalesce. 

Spoiler

REGEX: (\d{1,2}(-|\s)\w{1,4}(,|\s|-){1,2}\d{2,4})|(\w{1,4}(-|\s)\d{1,2}(,|\s|-){1,2}\d{2,4})

 

[derekbelyea]

Spoiler

[benjamin_feuchter]

Spoiler

[The_Rad_Valentina]

Could I used less parse tools? We will never know now. 

[davidhardister]

Struggle bus

[VictorCruz]

My solution 🙂

[anabelvelazque]

Hi! Here is my take 🙂

Spoiler

[bryonmiller]

Spoiler

Solution below

[Alteryx_AR]

My attempt