We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
7 - Meteor

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

 

vradcha1
7 - Meteor

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

ArtiRajput
9 - Comet

My attempt