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

rijuthav
6 - Meteoroid

My solution.

 

Used Data cleansing (same as Challenge #2)

estherb47
15 - Aurora
15 - Aurora
 
tom_montpool
12 - Quasar
 
Laurap1228
11 - Bolide

Practising my Regex :)

 

 

Spoiler
challenge16.jpg

 

MarvinPinto
6 - Meteoroid

Two solutions:

1: using the new data cleansing tool (Thank you @Alteryx for this tool)

2: using the Reg ex tool. @Seanadams i managed to work around the part where words were getting smashed into each other at he end of each line by using a blank value in the replacement text box.

LordNeilLord
15 - Aurora

This one seemed a little too easy?

 

Spoiler
Weekly Challenge 16.png
mceleavey
17 - Castor
17 - Castor

When that happens I always feel I've missed something...



Bulien

Anurag
6 - Meteoroid

My Solution

DE0413
8 - Asteroid
Spoiler
Week16Challenge.png
LordNeilLord
15 - Aurora

Workflow