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

OStoi
6 - Meteoroid

Done

kaitlinDS37
8 - Asteroid
Spoiler
kaitlinDS37_0-1686151421707.png

 

RossKillington
8 - Asteroid

 

Spoiler
altery challenge 4.png

 

Longa
8 - Asteroid

My solution can be found below.

TheOC
15 - Aurora
15 - Aurora

This challenge features one of my favourite hacks:

 

Spoiler
TheOC_0-1686583546058.png


Need to condense multiple columns to one?

TheOC_1-1686583561746.png


use the max function:

TheOC_2-1686583570231.png

 




Bulien
AndreeaS
8 - Asteroid
Spoiler
Screenshot 2023-06-12 165302.png
Aske_T
6 - Meteoroid

My solution using the Max formular, in the Formular tool. 

Computernerd
8 - Asteroid

My Solution

CSmith16
8 - Asteroid

My solution feels wrong. I got the correct output but this feels like it is badly done. Any advice would be much appreciated. I did not understand the formula used in the solution posted, nor did I want to copy the same regular expression in the RegEx tool. I did the best I could while trying to do it as different as possible.

 

RegEx expression: 

Spoiler
.*(\d{2}-\w+-\d{4})|.*(\u\w+\s\d+,*\s\d\d+)|.*(\d{2}-\w+-\d+)|.*(\d+-\w+-\d+)

Workflow: 

Spoiler
CSmith16_0-1686685572738.png

 

 

 

michael_apau
8 - Asteroid

michael_apau_0-1686774832555.png