Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAAnother 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.
My Solution: With RegEx parsing
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
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.
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.
thanks for the positivity.
Cheers,
Mark