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

Shiv_SKY
5 - Atom

It was deferent approach to solve this, enjoyed 

 

 

 

Thrill with sky

 

 

 

MalihaAthar
5 - Atom

Its a good challenge to practice Text to Columns and Data Cleansing Tool

 

Badger
6 - Meteoroid

Solution

rdiab
6 - Meteoroid

Solution to Challenge #2

RamaJ
7 - Meteor

Solution to Challenge 2. Just a beginner. 

missteran
7 - Meteor
Spoiler
Spoiler

missteran_0-1670441632492.png

 

Thanks for sharing this challenge, I had to use the solution for help and learned a new formula on Date, thanks!

oliver_inthavong
8 - Asteroid

My solution:

Spoiler
Challenge 2 Spoiler.png

Felipe_Ribeir0
16 - Nebula
Spoiler
Here is my solution, i am using regex to parse the data and the datetimeparse formula to format the date

Felipe_Ribeir0_0-1670505563005.png

 

olga_strubbe
10 - Fireball
Spoiler
olga_strubbe_0-1670512561854.png

 

A nice challenge on parsing data, thank you!

AlexTan07
5 - Atom

Here is my answer for this challenge

Spoiler
AlexTan07_0-1670514323644.png