We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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

RobertW
Alteryx
Alteryx

Wish there were a few more formatting options...

 

Spoiler
RobertW_0-1598980399472.png

 

LukaszKarpinski
8 - Asteroid

I took me more time than I anticipated but here it is:

 

Jayfay
7 - Meteor

A bit clunky, but I got there.

myouree
8 - Asteroid

My solution attached.

AkimasaKajitani
17 - Castor
17 - Castor

My Solution.

 

Spoiler
(\d+-[A-Z]+-\d+)|([a-zA-Z]+\s\d+[\s,]+\d+)

AkimasaKajitani_0-1599364105304.png

 

Tokimatsu
12 - Quasar
Spoiler
2020-09-14_12h21_59.png

Sashikumar
8 - Asteroid

👍

Spoiler
ch4.PNGch4_1.PNG
fluteman
9 - Comet

It's not pretty. Has some hard coding at the beginning. The data was not pretty at all!

One could key off the logging to derive something. I imagine the logging wasn't robust; but I went down the path of keying off the hyphen to split the string up.

liamholland
8 - Asteroid

Solution - definitely clunky but didn't want to use a lot of RegEx

Spoiler
Solution.png

 

Vishnu_Sekhar
7 - Meteor

My RegEx skills are very rusty and average. Alteryx helped me out with the dropdown tips. 

 

Solution attached.