Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

TerrenceM
8 - Asteroid
Spoiler
Challenge 4.png

lynnesonney
8 - Asteroid

wouldn't be as repeatable as others, but I got to the right spot!

asjohnson
Alteryx
Alteryx

Likely not the simplest

Spoiler
Screenshot 2024-04-11 212847.png
swethamadesh
5 - Atom

Hi,

 

My Regex skills are basic and here is my way of getting desired output

PFA.

 

 

DaisukeTsuchiya
14 - Magnetar
Spoiler
スクリーンショット 2024-04-19 070912.png
jgvillalta
6 - Meteoroid

My solution

Ed2000
8 - Asteroid
Spoiler
chal4.png
CE_5085781
6 - Meteoroid

My take on the solution...

Spoiler
Using two RegEx statements to find the numbers and possible months, before using a Find/Replace to clean the months (using a simple text input of JAN, FEB, MAR, etc), a formula to get the correct 4 digit year and then joining it all together....
Screenshot 2024-04-26 123050.png
barrymoe
7 - Meteor

Only attaching for historical sake, had to copy my solution. New to alteryx and only going through these to learn! Hopefully around challenge 100 I'll have more of my own answers 😂

Bobbyt23
12 - Quasar

Argh Regex, my old nemesis.

 

Spoiler
Still not one of my strong points so had to split it out to make sure I was getting it right.

 

Weekly Challenge 4.jpg