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

Dani_Lin
8 - Asteroid

solved

Damian_WRO
7 - Meteor

Done

nikhilnijhar
8 - Asteroid
Spoiler
Screenshot 2023-08-02 121104.png
NabilahLoti
8 - Asteroid

Work on writing regex and parsing the date from string

 

Spoiler
 

AlteryxGui_DBnW11yN4C.png

kmbassett01
8 - Asteroid

My solution - maybe not the most efficient, but I got there

Yoshiro_Fujimori
15 - Aurora

I think I solved this challenge before, but the challenge progress tracker says no. So tried again.

 

I could not make a RegEx which captures "27-JUN-70" and "4-SEP-00" at the same time.

So I parsed them separately. RegEx is still difficult to me...

 

 

Spoiler
Workflow
challenge_4_1.png

 

 

Krzysztof_Hyla_1986
8 - Asteroid

I went through entire course on RegEx but still needed to look at the solution. Most challenging task for me so far - learned a lot!

 

Spoiler
challenge_4_solution_KH.jpg

yuyadezaki
6 - Meteoroid

here is my solution.

Spoiler
Challenge_#4_Solution.png
Tgigs
8 - Asteroid

My solution attached.

 

Used regex tools to parse out the different dates, and then used date time tools to convert to dates. Not the prettiest solution but it gets the job done.

gawa
16 - Nebula
16 - Nebula

Parsing data is a kind of fun.

Spoiler
image.png