Challenge #4: Date Parsing

[george11]

my solution

[Sameera]

My solution

[rajenderk18]

Here is my solution:

1. First I use the RegEx tool to parse the date into 3 date format and create three additional column.
2. Then I use the formula tool to create a single Date format for all the three format in previous step.
3. Next step is to use the Select tool to select only those column which we need in final output and deselect all additional column, and rename the column same as needed in final output.
4. Then Use the browse tool to show the result.

5. Additionally, I use the join and filter tool to compare my results to the result provided in the question. And empty Browse tool output from the False anchor of filter tool indicate that my results are exactly same as the result provided in question.

Spoiler

[Cmacp433]

Hey p-g,

I am just starting to learn Regex and I love the simplicity of your solution!

A couple questions for you regarding your regex if you have a moment.

Questions

Your expression: "(\d+-\w{3,4}-\d+|\w{3,4} \d+,? \d+)"

1. When you use the pipe in the middle of the expression, because it is within the brackets and not prefaced with a \ that turns it into an "OR" statement? 
2. What is the ,? doing in the expression?

Thanks for your help! 

All the best,

Chad

[clmc9601]

My solution

[OnionKnight]

Took many hours and this is far from elegant... but finally I reached the goal...

[Cmacp433]

Practiced with different ways of writing Regex and got some practice with DateTime specifiers.

[Raiza]

My Solution for this challenge

[TraceyD]

On a roll...

[AlexHirstData]

Had to use some Regex.

Path 1 expression - \d{1,2}\D{3,}\d{2,4}

Path 2 expression - (\w{3}\s\d{1,2}\s\d{2,4})

Had to use two routes as the date to parse out was slightly different in row 3 and 9. Data cleansing to remove punctuation and a couple DateTimeParse tools for different formats. Lastly, Multi-Field formula to join the columns together, eliminating the null rows.