community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #4: Date Parsing

Alteryx
Alteryx

For only having one tool in my solution I am glad you can't see my run count while I sorted the regex out.

 

Went by identify each type of date format and adding it to the regex as and or (the pipe |) and then did the same number of steps to parse it, although had to do it as an elseif statement rather than the cleaner regex.

 

Spoiler
Workflow.png
Asteroid

Nice challenge for learning additional regex functionality

Highlighted
Asteroid

@MarqueeCrew

Thanks for your solution. I now know how to refer to marked groups in Regex formulas (e.g. $1) and went down a nice rabbit hole learning about lazy and greedy quantifiers to make sense of how the ".*?" behaved (which is much simpler than the workaround I came up with). 

Meteor
Spoiler
SpoilerSol4.PNG
Meteoroid

thanks for this .. intro to Regex

 

Alteryx Certified Partner

My first 'advanced' challenge!.. pure brute force to be honest

Meteor

Here's my version... I feel like there must be an easier way, but good practice with RegExs at least! Looking forward to seeing what others have done.

Atom
 
Meteoroid

Loved the tricks with sentences (marrying) and the date range (19 vs 20). Thanks!

Alteryx
Alteryx

First advanced challenge complete!