Challenge #4: Date Parsing

[Rob-Silk]

An interesting problem - my solution below:

Spoiler

I used the regex parse tool to tokenise the expected rough date format, which could be grouped into two main categories from a regex pattern point-of-view, and output to a new column which could then be converted to date format with the DateTime tool, again one for each of the two main regex patterns.

[B_SarkadiNagy]

Spoiler

[JasonW]

Spoiler

 

I went with the one tool approach

[Shoujain]

Here is my solution

[putu_w_erata]

Spoiler

 

[Aratryn]

Fun working with Regex

[asultanov]

Good regex challenge.

[Medha31]

Surely a great practice of regular expressions and string functions. Interesting Challenge!

[alhamzafri_khairin]

A good challenge, tried using Regex and some DateTime and Regex functions in Formula tool. 

[nSpire]

Spoiler