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

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