In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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

Myles_Stevenson
8 - Asteroid

Definetly not the optimal way but here is my solution 

Spoiler
Screenshot 2023-11-01 172308.png

ds_tomalexsmith
8 - Asteroid
Spoiler
Challenge 4 (flow).png

CoG
14 - Magnetar

Got to practice some Regex, which is always appreciated.

Spoiler
Workflow.png
danielprince
7 - Meteor

A great case scenario using RegEx, for this exercise I was able to resolve only using RegEx and forms

Spoiler
First RegEx use Parse the second use Replace
imagem_2023-11-08_115509326.png
JosFKirby
6 - Meteoroid

Just completed the RegEx training. This takes some practice, and these hands-on exercises really help. I saw three basic date instructions, which could be manipulated individually, and then converted back to dates. 

ecvaldez10
5 - Atom

Here's my solution

shrestha_nitesh
8 - Asteroid

Challenge 4 Screenshot.png

ToniZheng
6 - Meteoroid

Fun Regex practice.

StevenP
8 - Asteroid

My Solution:

 

Spoiler
image.png
Regex Date Parse formula: (\d{1,2}-\D+-\d{2,4}|\D{3} \d{1,2}, \d{2,4}|\D{3} \d{1,2} \d{2,4})

 

 

BrianJohnson
8 - Asteroid

Thank you for the great challenge.  REGEX has not been a strongpoint of mine so it was a great learning experience.  I had first tried to use REGEX within the formula tool to avoid creating extra columns, but had trouble making that work so I went forward with the REGEX tool.