Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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

whalesun
6 - Meteoroid

whalesun_0-1591851158671.png

 

aeaston
5 - Atom

Straightforward and good practice

Inactive User
Not applicable

Challenge#2

dvhout
5 - Atom

Final

The_Rad_Valentina
8 - Asteroid

Challenge completed!

 

vradcha1_1-1591983790428.png

 

p3rceptop
6 - Meteoroid

Here's my solution (total of 2), but the original post's solution is still better than mine from certain perspectives.  Plus I learn a new formula from it today!

ncrlelia
11 - Bolide

Challenge 2

Divya_Kumar
6 - Meteoroid
Spoiler
Spoiler

Divya_Kumar_0-1592050948373.png

 

Leeia_I
9 - Comet

Here is my solution. 

 

Spoiler
LeeiaI_0-1592051603181.png

 

rinair
6 - Meteoroid

Here is my solution, I didn't exactly understand the date time parse used in formula, what does %b stand for?