Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #4: Date Parsing

JoeS
Alteryx Alumni (Retired)

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
Paul-Evans
9 - Comet

Nice challenge for learning additional regex functionality

Paul-Evans
9 - Comet

@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). 

Shivam
8 - Asteroid
Spoiler
SpoilerSol4.PNG
allanq2001
6 - Meteoroid

thanks for this .. intro to Regex

 

jssandom
8 - Asteroid

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

HuwHallam
8 - Asteroid

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.

annangip
5 - Atom
 
mek201gs
6 - Meteoroid

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

JamesMA
Alteryx Alumni (Retired)

First advanced challenge complete!