We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. 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

Rob-Silk
8 - Asteroid

An interesting problem - my solution below:

Spoiler
I used the regex parse tool to tokenise the expected rough date format, which could be grouped into two main categories from a regex pattern point-of-view, and output to a new column which could then be converted to date format with the DateTime tool, again one for each of the two main regex patterns.

challenge_4_RS_screencap.PNG
B_SarkadiNagy
6 - Meteoroid
Spoiler
2023-12-05_17h37_29.png
JasonW
6 - Meteoroid
Spoiler
004 Solution2.png

I went with the one tool approach

Shoujain
6 - Meteoroid

Here is my solution

putu_w_erata
8 - Asteroid
Spoiler
 
Capture.JPG

Aratryn
7 - Meteor

Fun working with Regex

asultanov
8 - Asteroid

Good regex challenge.

Medha31
8 - Asteroid

Surely a great practice of regular expressions and string functions. Interesting Challenge!

A good challenge, tried using Regex and some DateTime and Regex functions in Formula tool. 

nSpire
8 - Asteroid
Spoiler
004.png