community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #16: Parsing Out the New-line Character

Meteoroid

My solution.

 

Used Data cleansing (same as Challenge #2)

Quasar
 
Alteryx Partner
 
Alteryx Certified Partner

Practising my Regex :)

 

 

Spoiler
challenge16.jpg

 

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.

Alteryx Certified Partner

This one seemed a little too easy?

 

Spoiler
Weekly Challenge 16.png
Alteryx Certified Partner

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

Meteoroid

My Solution

Highlighted
Asteroid
Spoiler
Week16Challenge.png
Alteryx Certified Partner

Workflow