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

uk_msmt
8 - Asteroid
Spoiler
uk_msmt_0-1611674242583.png

 

Here is my solution.

GeoEdgarC
5 - Atom

Here's my solution.  I had no idea there was such a thing as a "StripQuotes" function until today.

Salvatore_Miseo
7 - Meteor

Hello everyone below my solution
I used a multi-field formula to get rid of the quotes and later the tuol DateTime to format the date.

 

In fact the "Trim" function is very powerful with the "DateTimeParse" function as well. In one step it is possible to both rename the fields and perform the two previous steps.

Very beautifull!!

PHinkel
7 - Meteor

Hi,

 

Attached is my solution.

ptmyen
7 - Meteor

my solution 🙂

KamilKa
5 - Atom

Nice training, thanks!

stallan
5 - Atom
Spoiler
stallan_0-1612301938243.png

 

binuacs
20 - Arcturus
Spoiler
challenge_2_solution_binu.PNG

my solution 

MarkusLiedtke
6 - Meteoroid

  

manny890-
7 - Meteor

My Solution: