community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #4: Date Parsing

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

Highlighted
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
Customer Support Engineer
Alteryx, Inc.
Asteroid
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