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 #2: Preparing Delimited Data

mpg222
7 - Meteor
Spoiler
For this solution I used a couple other formulas and tools than the solution file. I still used a text to column on the commas. Then I used two formulas with the StripQuotes function to clean up the text and date columns. Finally, I used the convert date tool to format the final column.
Capture.JPG
Capture2.JPG
Capture3.JPG
simbert
8 - Asteroid

Adding the workflow

gffcoutinho
7 - Meteor

Here's my take.

Bizu
6 - Meteoroid

Here is my solution

Jayfay
7 - Meteor
Spoiler
 
Chandashravani
5 - Atom

Appreciate your solution. I have done it little different, instead of trim function i have used replace function, and also used Date Time function for converting. I personally prefer Date time tool for converting the dates, it is very easy when compared to expression in formula. Appreciate your solution. 

ijkiv
6 - Meteoroid

My solution turned out to be a bit less elegant that the official one, as I used a few more tools, but it got the job done. 

JazzmanDoesData
6 - Meteoroid

Solved and done!

 

CKent
6 - Meteoroid

I always enjoy a parsing challenge 🙂

HeatherMHarris
11 - Bolide

 

Practicing regular expressions...

 

 

Spoiler
challenge_2_start_file_hh.PNG