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
Asteroide
Saqueador
uk_msmt_0-1611674242583.png

 

Here is my solution.

GeoEdgarC
Átomo

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

Salvatore_Miseo
Meteoro

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
Meteoro

Hi,

 

Attached is my solution.

ptmyen
Meteoro

my solution 🙂

KamilKa
Átomo

Nice training, thanks!

stallan
Átomo
Saqueador
stallan_0-1612301938243.png

 

binuacs
Arcturus
Saqueador
challenge_2_solution_binu.PNG

my solution 

MarkusLiedtke
Meteoroide

  

manny890-
Meteoro

My Solution: