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
Alteryx
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})