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.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com
alteryx Community

# 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

Alteryx

Advanced level - check. Pretty challenging

Spencer Hong
Competitive Intelligence Analyst, Product Management
Alteryx
Alteryx

My solution:

Spoiler

8 - Asteroid

I liked practicing Regular Expression

My solution..

Update:

I improved my solution, reduced the number of tools in the canvas from 9 to 5

12 - Quasar

Decided to try to write one massive formula to handle the date conversion after the RegEx parsing. Fun challenge!

Spoiler

``DateTimeParse(IIF(IsEmpty([RegExOut1]),trim(left(REGEX_Replace([RegExOut2], '[[:alpha:]]', ''),3))+'-'+Trim(REGEX_Replace([RegExOut2], '([^][a-z])', ''))+'-'+Trim(right(REGEX_Replace([RegExOut2], '[[:alpha:]]', ''),4)),[RegExOut1]),'%d-%b-%Y')​``

6 - Meteoroid

My solution.

Spoiler

7 - Meteor

my soultion!

6 - Meteoroid

Here is my solution.

7 - Meteor
Spoiler

8 - Asteroid
Spoiler
8 - Asteroid
Spoiler

First one tool solution! Probably could rationalise expression further using or (|) in the regex.