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

LukasJennings
8 - Asteroid
Spoiler
LukasJennings_0-1614601759059.png

 

Kakuffo
Alteryx
Alteryx

Good introduction to Regex

 

 

Spoiler
Kakuffo_0-1615207920444.png

 

AndyBate
8 - Asteroid

😀

 

Toons
12 - Quasar

My solution :

 

 

Spoiler
Toons_0-1615369951266.png

 

Toons_2-1615370007330.pngToons_1-1615369971434.png

 

 

 

 

rcarog
8 - Asteroid

Solution attached.

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

Things to learn:

YOU CAN!

  • RegEx: There's no way around it if you are going to ever get unstructured data, and trust me, you will. There will be someone who'd ask you to scan the body of the email someday, so for that day: try out https://regexr.com/, and if you still feel nervous Alteryx's Regex tool has help in the spoiler below
  • Attention to Detail: What separates you from others? DateTime Parse tool like in previous challenge 2 will help you here, but Alteryx autocalculates some years, so use a formula tool like I did!
    Spoiler
    Solution_4.PNG
federicohernandezd
6 - Meteoroid

This was a challenge, gotta practice more the Regex symbols. Any recommendations for practicing?

 

 

Greetings,

 

Federico

AlexPeacock
8 - Asteroid

My Solution

 

Luke_C
17 - Castor
Spoiler
Luke_C_0-1617377490373.png

 

lewanark
8 - Asteroid
Spoiler
lewanark_0-1617722941861.png