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

ErenErdogan
7 - Meteor

Hi all,

 

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

 

Spoiler
WeeklyChallenge4.GIF

 

Regards,
Eren.

Lindsen
6 - Meteoroid

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
ConradW
8 - Asteroid

Challenge 4 complete

FRANCK_ROUQUETTE
8 - Asteroid
Thank you for the exercise - here is my proposed solution.
mmenth
11 - Bolide

This was a cool one!

 

Spoiler
challenge 4.PNG
SophiaF
Alteryx
Alteryx

RecordID!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Senior Solutions Architect
Alteryx, Inc.
AndrewS
11 - Bolide
Spoiler
spoiler4.png

 

Regex101.com!!

chetty
8 - Asteroid

My solution attached

wdavis
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. 

Jur
7 - Meteor

My solution:

 

Spoiler
Challenge_4_JP.png