Challenge #4: Date Parsing

[DataHabanero]

Very exciting challenge. I hadn´t had the chance to do much parsing since I try to do that before I enter data to Alteryx. I don't think the solution is as elegant as it might be but it does the trick. I'm exicted to see how other people managed to attack the problem.

[hbraunius]

My solution attached.

[MitchKibble]

There's probably a more efficient way to do this but it worked.

[Alekh]

Spoiler

 

[DataHabanero]

Definitely, I went through the solution proposed by the team and it was clear that using the parsing tool is way easier.

[Bunny82]

Solution attached, regex is very interesting happy to learn more about regex!

[TonyA]

Here's my solution. Got it down to four tools not counting Browse.

[apoorvashetty]

I'm a beginner so my approach is slightly rough on the edges. I used two RegEx tools one for the Values with "-Mon- " format and another for the remaining values. I used the RegEx-parse option  in both to get Date,Month and Year columns. I used DataCleansing and Formula toools to format these. After using union for the two sets,I finally used DateTimeFormat to convert it into a standard format. 

Loved the official solution,great learning experience. 

[DiegoParker]

I went for a couple more tools instead of over complicated regex. Here it is!

[nickjastrzebski]

I tried a few approaches to this but settled on RegEx as the most elegant option for extracting the dates.

Spoiler