Free Trial

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 #16: Parsing Out the New-line Character

MaxGiegerich
8 - Asteroid

Very easy but good to know it's done exactly how you'd expect!

data_rachel
8 - Asteroid
Spoiler
challenge16.PNG
marcreid
7 - Meteor

My solution

Spoiler
image.png
hoheusle
6 - Meteoroid
Spoiler
Spoiler

quick and easy one, but useful because I hadn't used this tool yet. 

JoshKushner
12 - Quasar

Love the omage back to Challenge #4

dominiklz
8 - Asteroid
Spoiler
16.PNG
930realm
7 - Meteor

Fixed it correctly the first time, but as others have pointed out the output was had the words smashed together. So I corrected the output.

dsmdavid
11 - Bolide

Useful data cleansing toool!

lizpunct
5 - Atom

DateTime tool creates new column with converted field.

Given that I would use the Select tool early on, I placed DateTime first, to avoid extra operations.

Assuming potentially more rows, I generally use Data Cleansing tool to Remove Unwanted Characters: Leading and Trailing Whitespace and Tabs, Line Breaks, and Duplicate Whitespace.

 

Any suggestions on how (if) this could be more efficient? :)

16 Parsing Out the New-line Character.png

 

samN
10 - Fireball

My Solution doesn't quite match the given answer as i have a space where the tab was. But i think this is more complete anyways.