Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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