In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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

cspartz
6 - Meteoroid

Could definitely be slimmed down if I took another crack at it. 

kvnpt
7 - Meteor

Difficult for someone who has never come across RegEx before.  Certainly a crash course.  I split my flow into 4 as to treat each date type differently.

 

Spoiler
Challenge 4.PNG
justin_winter
8 - Asteroid

Lots of regex, but got it up and running.

jfgirouard
7 - Meteor

My solution.  Quite a little brain twister!

EEdLoh
8 - Asteroid

The Regex Parse tool captures both possible formats in a single column. The proceeding formula uses regex_match to determine which pattern if follows, then submits to DateTimeParse with the appropriate format string.

danrh
13 - Pulsar
 
ydmuley
12 - Quasar
12 - Quasar

Struggled initially with this, but finally was able to do it with the help of https://regex101.com/

 

Thanks, @SeanAdams for suggesting this sit

 

The solving thrill continues!!!!!!!!!!!!!!!!

Regards,
Yugandhar Muley (Yug)

Alteryx ACE | Alteryx For Good India Lead | Bengaluru Alteryx User Group Lead
FabianS_dup_107
7 - Meteor

My solution to the problem, just useing regex and datetime tool :)

Mikkel_D_Karlsen
8 - Asteroid

My Solution

neilgallen
12 - Quasar

Probably a more direct way to do this with less tools, but gets the job done.