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

Evanachi
6 - Meteoroid

Challenge 2

iakovidc
7 - Meteor
Spoiler
Capture.PNG
Razzle
6 - Meteoroid

Loving the challenges!

Sntrada
11 - Bolide

Here is my solution. I used text to columns to parse, then the DateTime tool for the date conversion, and then a couple of select tools to do some housekeeping.  

StellaBon
11 - Bolide

Here was my solution which took extra time mucking around in the DateTime Parse tool to get right. I will definitely look into the ways this can be done in the Formulas tool going forward. Thanks!

dsaikat
5 - Atom

Solved

evw19
6 - Meteoroid

Here are my solutions!

vaishabhinav_iitm
6 - Meteoroid

vaishabhinav_iitm_0-1590788945455.png

 

Faaiz26
6 - Meteoroid

Here is my solution to this challenge . I use Text to column tool with formula and date time tool to complete this

DavidWebb
6 - Meteoroid

Nice easy task to get off the mark.