In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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

aly33
5 - Atom

Here is my solution

gawa
16 - Nebula
16 - Nebula

As cannot edit last post, upload solution as a new post

olivier_newman
8 - Asteroid

Not sure I've done this the most effective way but got there eventually 

perin
8 - Asteroid

A few steps and the magic is done!image.png

TheOC
16 - Nebula
16 - Nebula

A spicy Regex challenge

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
InchulKo
7 - Meteor

Here is my solution!

EnglishmaninNY
8 - Asteroid

I used a similar initial approach but separate out each regex output in a separate tool. I was also a little more catch all. Anyway review the solution certain brought up my knowledge of regex up a notch.

 

Not sure I understood the need to parse out the different date components. I just put in a formula and DateTimeParsed with a if statement to change the parameter appropriate for each category.

 

Spoiler
Screenshot 2023-09-15 153106.png
orangebomber
7 - Meteor

spoiler

aangsg
7 - Meteor
Spoiler
Ch4.PNG

wow this was hard!

williamnolan03
8 - Asteroid

This one was fun to stretch my brain on!