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

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.