Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Lily_Unsworth
8 - Asteroid
 
Reesetrain2
9 - Comet

All,

 

I used a bit of a waterfall method in my approach.

-First, two of the dates use hyphens (-), so I was able to use Tex to Columns to parse those, and then use left and right in order to gather the rest of the date.

-The third, used a comma, so I was able to parse the comma and then use Text to Column to grab the year and day on either side.

-Finally, I had to use Regex for the final date.

-Again, I have created my solutions to use a little custom code as possible.

-Cheers!

Matt

Hannah_Lissaman
11 - Bolide

My solution - not a complete solution by any means, but it works for all the variations of dates included in the challenge

Greg_Murray
12 - Quasar

Not pretty, but solved

rowenb
6 - Meteoroid

I liked this challenge.

Spoiler
My one roadblock was finding a way to evaluate MM-dd-yyyy separately from dd-MM-yyyy. Eventually I realized I could just duplicate my workflow and run it twice (once per case).
Spoiler
layout.png

 

garthn555
8 - Asteroid
Spoiler
gn_challenge_4.png

My solution uses more tools but there is less code and it is easier to understand - it leverages the power of the DateTime tool

DanielMS
Alteryx
Alteryx
Spoiler
Spoiler.PNG
VizAlly
6 - Meteoroid
Spoiler
bk_challenge4.png
arno_bürgin
7 - Meteor

Solution attached.

 

Spoiler
screenshot challenge 4.png
Vidya26
8 - Asteroid

Litlle lengthy !!!