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.