Challenge #4: Date Parsing

[Elias_Nordlinder]

Solved, fun little exercise.

Spoiler

[j_christian]

Spoiler

Regular expressions and DateTimeParse make this less difficult than it looks.  However, if this was a real request for parsing out datetime from lots of strings, I'd advise using a library instead of writing the regular expressions, since these expressions will also pull nonsense strings of text and digits that match the date format..

[ExploreMore]

Spoiler

First one I've solved in a while. I managed to solve using just one RegEx and Formula tool!

[BobHaan]

Spoiler

I used two different RegEx expressions to pull out the dates:

(\d{1,2}[- ][a-zA-Z]{3,10}[- ]\d{2,4})       parses 16-APR-2005, 4-SEP-00

    ⦁ 1 to 2 digits                                                 \d{1,2}
    ⦁ either a dash ("-") or a space (" ")    [- ]
    ⦁ 3 to 10 letters                                           [a-zA-Z]{3,10} ---OR--- \D{3,10} ---OR--- [[:alpha:]]{3,10}
    ⦁ either a dash ("-") or a space (" ")    [- ]
    ⦁ 2 to 4 digits                                                 \d{2,4}

([a-zA-Z]{3}\s\d{1,2}[,]{0,1}\s\d{2,4})     parses Nov 16, 1900, Jan 5 2000

    ⦁ 3 letters                                                        [a-zA-Z]{3,10} ---OR--- \D{3,10} ---OR--- [[:alpha:]]{3,10}
    ⦁ a space (" ")                                                  \s
    ⦁ 1 to 2 digits                                                 \d{1,2}
    ⦁ an optional comma                                [,]{0,1}
    ⦁ a space (")                                                    \s

    ⦁ 2 to 4 digits                                                 \d{2,4}

I then use a formula to convert the RegEx Results into a useable date field:

This is one of the shorter solutions.  Note that the two RegEx functions could be combined into a single tool.

[IraWatt]

Maybe not the most efficient way but managed to parse them all. 

Spoiler

[carmenrapariz]

Spoiler

[caitlynmcintyre]

I truly think this could be done in one tool but RegEx hurts my brain

Spoiler

[MikeDroog]

not the most elegant without a date parse tool but it works

[Freddy123]

Spoiler

[JXEC]

RegEx is my bane.

Here's my solution.