Challenge #4: Date Parsing

[sabaker]

solution attached

[zkibz16]

See attached for a Challenge #4 solution

[Jacob_Jacobsen]

Spoiler

This was educational! It was also a challenge to convert regex from the dedicated tool for use in the Formula tool since they are not equivalent - in the Regex_Replace formula I missing an option to disable "Copy unmatched text to to output" (default in Regex_Replace formula), like in the dedicated Regex tool which required modified expressions for a single tool solution.

[TarunDeep]

Great learning on Regex and date parsing.

Spoiler

[selliott69]

I found this pretty challenging, but I really needed a RegEx refresher so it was a really good exercise for me.  Dates are challenging and I tend to deal with them more than I care to admit.

Thanks!

-Shawn

[DanielG]

A bit clunky as I am newer to RegEx.  Trying to get more comfortable with it after years of denying its existence.  I got it to work for this particular dataset, but not sure it would be that great for an everchanging datasource.

[alexm06]

Long winded solution

[Vanzeup7]

Here's my solution. Thanks.

[PHinkel]

Hi,

Attached is my solution.

[Animanga008]

Good one, video: Challenge 4 Video