Challenge #4: Date Parsing

[asteryx]

Another good lesson - from trying the challenge and reading through the other solutions (@markp201 and@MarqueeCrew showing off some RegEx skills).

I should have thought of a simple formula in a new field to concatenate the RegEx results, but did a Transpose/Summarize instead.

Spoiler

[elliemason]

Fun developing Regex skills - made myself do it within one tool using the '|' or operator!

[RobertoEstrada]

OK, not sure if it is the best solution but it was fun to work on it.

[TimothySr]

My Solution: With RegEx parsing

Spoiler

One column Regular expression: .*((?:\d{2}-|(?:\l)\d-|\u\l{2}\s\d+)(?:\u+-|\s|,\s)(?:\d{4}|\d{2})).*
Identified and parsed All Dates into one column

[kennetheng]

Great way to learn RegEx. 

For some reason doing /d+ at the beginning of a parse would only grab one of the digits for me, every time. So I ended up having to do five columns for that one date that had a single digit day: 

.*(\d\d-[[:alpha:]][[:alpha:]][[:alpha:]]-\d+).*|

.*([[:alpha:]][[:alpha:]][[:alpha:]]\s\d+,\s\d+).*|

.*(\d\d+-[[:alpha:]]+-\d+).*|

.*([[:alpha:]]{3,4}\s\d+\s\d+).*|

.*(\d-[[:alpha:]][[:alpha:]][[:alpha:]]-\d+).*

Definitely a super useful capability I was unaware of. 

[Scott_Anderson]

Solution attached!

[jwilson1]

Not the most flexible way to accomplish this, but it matches the answer. 

[PeterGoldey]

Good thing I brushed up on RegEx at the conference.  Definitely a struggle. 

[john_miller9]

Great opportunity to dive deeper into Regex.  Had a very clunky response until I looked at @MarqueeCrew 's solution which really helped me better understand approaching a regex challenge.

Spoiler

[MarqueeCrew]

@john_miller9

thanks for the positivity. 

Cheers,

Mark