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.