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

tanyafischer
8 - Asteroid

First Weekly Challenge solved :)

eboughton
8 - Asteroid

Completed

chloe_portanger
5 - Atom

A simple challenge, but a nice reminder of how to remove delimiters.

 

Spoiler
challenge_2_chloe_portanger.jpg
cjmayes
8 - Asteroid

challenge 2

Anna_Olkuska
5 - Atom

Hi All!
My idea was to use text to columns on all delimiters (skip empty columns) then DateTime tool to convert date and select tool to have only needed data- worked well ;)

JamesCharnley
13 - Pulsar

Good parsing practise. Not as efficient as it probably could have been but if it works it works I guess

 

Spoiler
JamesCharnley_0-1645629038545.png

 

Oliver-Corbin
7 - Meteor

Not too different from the given solution :)

DataNath
17 - Castor

My solution for #2.

 

Spoiler
DataNath_0-1645556569916.png

 

QuantumViridis
7 - Meteor

My solution

Chris_Spartz
5 - Atom

Solved.