Challenge #4: Date Parsing

[Reesetrain2]

All,

I used a bit of a waterfall method in my approach.

-First, two of the dates use hyphens (-), so I was able to use Tex to Columns to parse those, and then use left and right in order to gather the rest of the date.

-The third, used a comma, so I was able to parse the comma and then use Text to Column to grab the year and day on either side.

-Finally, I had to use Regex for the final date.

-Again, I have created my solutions to use a little custom code as possible.

-Cheers!

Matt

[Hannah_Lissaman]

My solution - not a complete solution by any means, but it works for all the variations of dates included in the challenge

[Greg_Murray]

Not pretty, but solved

[rowenb]

I liked this challenge.

Spoiler

My one roadblock was finding a way to evaluate MM-dd-yyyy separately from dd-MM-yyyy. Eventually I realized I could just duplicate my workflow and run it twice (once per case).

Spoiler

[garthn555]

Spoiler

My solution uses more tools but there is less code and it is easier to understand - it leverages the power of the DateTime tool

[DanielMS]

Spoiler

[VizAlly]

Spoiler

[arno_bürgin]

Solution attached.

Spoiler

[Vidya26]

Litlle lengthy !!!