Challenge #4: Date Parsing

[KOBoyle]

Solution attached.  I wasn't familiar with RegEx, so I needed to do some research and peak at the solution.  I found using a single formula after the RegEx parse to be simpler.

Ken

[Philip]

Weekly challenge 4 done.

Spoiler

Formula tool:
IF REGEX_Match([Field_11], "\d+-\u{3}-\d{2}")
    THEN DateTimeParse([Field_11], "%d-%b-%y")
ELSEIF REGEX_Match([Field_11], "\d+-\u{3}-\d{4}")
    THEN DateTimeParse([Field_11], "%d-%b-%Y")
ELSEIF REGEX_Match([Field_11], "\d+-[\u\l]+-\d{4}")
    THEN DateTimeParse([Field_11], "%d-%B-%Y")
ELSEIF REGEX_Match([Field_11], "[\u\l]{3} \d+, \d{4}")
    THEN DateTimeParse([Field_11], "%b %d, %Y")
ELSEIF REGEX_Match([Field_11], "[\u\l]+ \d+ \d{4}")
    THEN DateTimeParse([Field_11], "%B %d %Y")
ELSE NULL()
ENDIF

[JORGE4900]

I really enjoyed working on this solution because I appreciate the advantages of regular expressions. On my first try, I did a long version of columns using additional regex tools; on my second try, I used a slightly different approach with a single regex tool. Somehow on this last try, I ended up parsing a T on column 6.

I guess that I should have used the two or more digits option instead of forcing the two and four digit year onto their own columns.

[JORGE4900]

That was a pretty good solution @MarqueeCrew

[nick_ceneviva]

Awesome challenge to use the RegEx tool.  Solution is attached.

[PhilipMannering]

I love my regex. Still not up to @MarqueeCrew's standards though...

Spoiler

[MarqueeCrew]

Thanks for the mention!

[Amarendra]

This link from @AlexKo helped me understand the 'RegEx' Thank you Alex for such a comprehensive resource.
Attached is the 4th challenge solution.

[dheerajpoojari]

My solution attached. was a good refresher to regex

Spoiler

[derekbelyea]

This was a good exercise to reinforce my regex skills.  My solution looks similar to others I found here.

Derek