community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #4: Date Parsing

Highlighted
Meteor

Hi all,

 

I used a simple macro to parse out the necessary data, take a look:

 

Spoiler
WeeklyChallenge4.GIF

 

Regards,
Eren.

Alteryx Partner

I tried to give Regular expressions a go.. Not as neat as I want it to be, but it did the job.

 

Spoiler
output.PNG
Alteryx Partner

Challenge 4 complete

Asteroid
Thank you for the exercise - here is my proposed solution.
Bolide

This was a cool one!

 

Spoiler
challenge 4.PNG
Moderator
Moderator

RecordID!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Premium Support Advisor
Alteryx, Inc.
Comet
Spoiler
spoiler4.png

 

Regex101.com!!

Asteroid

My solution attached

Alteryx
Alteryx

My Regex skills not quite as adept, so parsed out 6 different versions of the date format then used 6 separate datetime tools to convert them back. 

Alteryx Partner

My solution:

 

Spoiler
Challenge_4_JP.png