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

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

spencerhong
Alteryx
Alteryx

Advanced level - check. Pretty challenging

Spencer Hong
Competitive Intelligence Analyst, Product Management
Alteryx
CandiceDB
Alteryx
Alteryx

My solution:

 

Spoiler
CandiceDB_0-1618346549250.png

 

RashedDS
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

Maskell_Rascal
12 - Quasar

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

Spoiler
Maskell_Rascal_0-1618857183555.png
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')​

 

AdrianMa
6 - Meteoroid

My solution.

Spoiler
AdrianMa_0-1619328331858.png

 

Lili1
7 - Meteor

my soultion!

bandhakaviarun
6 - Meteoroid

Here is my solution.

SWalker
7 - Meteor
Spoiler
Challenge_4_Preview.png

Steph_Maddrell
8 - Asteroid
Spoiler
Steph_Maddrell_0-1620313687584.png
ENix
8 - Asteroid
Spoiler

ENix_0-1620397741343.png

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