We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
11 - Bolide

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
6 - Meteoroid

Not too different from the given solution :)

DataNath
16 - Nebula

My solution for #2.

 

Spoiler
DataNath_0-1645556569916.png

 

QuantumViridis
7 - Meteor

My solution

Chris_Spartz
5 - Atom

Solved.