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

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

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.