Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

bdaniels
8 - Asteroid

Date parsing: Always a good time

shoesnsocks4
7 - Meteor

This one was fun.

TerryT
Alteryx Alumni (Retired)

...adding my solution:

 

Spoiler
challenge_4_TTT.PNG
SimonaLoffredo
6 - Meteoroid

Not the most elegant solution but I am not very skilled in parsing :) Interesting challenge though! 

ivoller
12 - Quasar

After some trial and error, got it much simplified. Good one!

kelly_gilbert
13 - Pulsar

I can never get enough practice on date conversion.  So useful!

 

Spoiler
I didn't think about doing this all in one regex tool - that is much cleaner than the four separate tools I used.
CHarrison
8 - Asteroid

Just recently learnt how to RegEx, good challenge to practise my new skill with! 

DanielArenas
7 - Meteor
 
joshuaburkhow
ACE Emeritus
ACE Emeritus

obviously this was done a while ago but after completing this then looking at the solution, I'd like to believe that the way I did it here might be a little bit easier as its doesn't require as complex regex and parsing out as much but more of using some of the newer tools since this was posted. A very important exercise in parsing none-the-less :)

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
locunhalima
7 - Meteor

Follow attached my solution.