Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

jestinejoseph
8 - Asteroid

Parsing the field was difficult however, completed using just three tools. Regex, Formula and Select. Took some to time to get the correct output.

 

jestinejoseph_0-1637864817166.png

 

AmandaH
8 - Asteroid

This was a fun challenge! I used regex to parse the two date variations from the strings, and then DateTime tools to parse the date formats and a formula to coalesce. 

 

Spoiler
REGEX: (\d{1,2}(-|\s)\w{1,4}(,|\s|-){1,2}\d{2,4})|(\w{1,4}(-|\s)\d{1,2}(,|\s|-){1,2}\d{2,4})

Solution_AmandaHutson.PNG

derekbelyea
12 - Quasar
Spoiler

derekbelyea_0-1638747594845.png

 

benjamin_feuchter
8 - Asteroid
Spoiler
benjamin_feuchter_0-1639129170207.png

 

The_Rad_Valentina
8 - Asteroid

Could I used less parse tools? We will never know now. 

davidhardister
8 - Asteroid

Struggle bus

VictorCruz
Alteryx
Alteryx

My solution 🙂

Victor Cruz
Sales Engineer, LATAM
Alteryx
anabelvelazque
8 - Asteroid

Hi! Here is my take 🙂

 

Spoiler
anabelvelazque_0-1640791479868.png

 

bryonmiller
6 - Meteoroid
Spoiler
bryonmiller_0-1640807691047.png

 

Solution below

Alteryx_AR
12 - Quasar

My attempt