Weekly Challenge

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

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

Submit Feedback
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.

Challenge #4: Date Parsing

Highlighted
8 - Asteroid
Spoiler
Just realized that I didn't attach the file!
Highlighted
6 - Meteoroid
 
Highlighted
Alteryx Certified Partner

Solution to Challenge #4 attached below.  

Highlighted
8 - Asteroid

I really enjoyed this one! I wasn't able to capture every date entirely in one regex group.

I instead parsed into 2 groups and used to date calcs to do the rest.

JonathanW_0-1578268183596.png

Highlighted
Alteryx
Alteryx
Spoiler
Used BB Date Macro
Challenge 4.png

Solution attached

Highlighted
6 - Meteoroid
Spoiler
Solution_Daniel_Challenge 4.png
Highlighted
8 - Asteroid

 

Spoiler
acrahen_34-1578322447457.png

Fun one

 

Highlighted
8 - Asteroid

Her's my dig to the challenge. Good test of my regex learning.

 

Spoiler
Challenge_4_Mdodrajka.PNG

Highlighted
8 - Asteroid

Wow! this was a super efficient way to solve. I was feeling so proud to have been able to do it in fewer steps than most, but your solution beats all. Hats off.

 

Here's what I did.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-4-Date-Parsing/m-p/510628/highlight/true...

Highlighted
8 - Asteroid

Complete!