ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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

AlejandroMS
6 - Meteoroid

Great exercise, really helped me understand the potential of teh RegEx tool!

JasonTylerYoung
8 - Asteroid
Spoiler
Great exercise with parsing and date/time functions in the formula tool.
Ajjay
8 - Asteroid

Solution

Agnieszka_Kiryla
6 - Meteoroid

Very interesting Challenge 🙂 Thanks for preparing that!

kklc24
7 - Meteor

Solution

Spoiler
kklc24_0-1624537013555.png

 

Tomasch
7 - Meteor

done

Spoiler
Tomasch_0-1625142234431.png

RegEx formula: (?:)(\d{1,2}-\u+-\d{2,4})|(\w{3}\s\d+.+\d{4})

DanTh
Alteryx Alumni (Retired)
Spoiler
Took me a little second to land on RegEx, but the Regular Expression Builder was a lifesaver. Having looked at the solution, I could have been more efficient by using a single RegEx tool and using the OR character.

4/5
AliAgah
8 - Asteroid
Spoiler
AliAgah_1-1625587173415.png

 

The first alteryx Advanced challenge I've completed without any guidance! My solution isn't as elegant but proud nonetheless.

JoaoLeiteV
10 - Fireball

One more challenge done! Used one Regex to parse 2 possible combinations, then a formula for all the rest.

 

Spoiler
JoaoLeiteV_0-1625861817199.png

 

GarryBrittain
6 - Meteoroid

Been a while since I've used RegEx, good stuff.

 

Spoiler
GarryBrittain_0-1626056114831.png

Two RegEx commands:
(\d{1,2}.{1,2}[[:alpha:]]+.{1,2}\d{2,4})
([[:alpha:]]+.{1,2}\d{1,2}.{1,2}\d{2,4})