Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1670605218716.png

 

davidnordstrom
6 - Meteoroid

4

JoeChan619
8 - Asteroid

I think this challenge should not be categorized as difficulty level. Using Regex can solve it easily.

Ereon
7 - Meteor

Learning how to master RegEx is fun!  Was able to get a simple RegEx to parse out the dates into only 3 columns but then had to do more to Replace those to match the majority column.

First RegEx used:
(\d*-\u+-\d*)|(\w+ \d*, \d*)|(\w+ \d* \d*)

lhalliwell
8 - Asteroid
Spoiler
Regex: ((?:[A-Za-z]|[0-9]){1,3}(?:\s|-)\w{1,4},*(?:\s|-)(?:\d{4}|\d{2})),*'*\w+
Screenshot 2022-12-21 120530.jpg
Angelica_Obi
8 - Asteroid

Spoiler

MajdiSalie
7 - Meteor

Solution:

MajdiSalie_0-1671701631172.png

 

gautiergodard
13 - Pulsar
Spoiler
Solution attached!
dwstada
11 - Bolide

my solution :)

 

Spoiler
dwstada_0-1671722679527.png

 

TyroneW
Alteryx Alumni (Retired)

Challenge 4 attached.