ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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

MalluShroomer
7 - Meteor

Done

maicolpolvere
6 - Meteoroid

Thank you for the Challenge! Very Interesting! Here my solution with some comments.

 

Maicol Polvere - Sprint Reply Srl

j_trefethen
8 - Asteroid
Spoiler
Challenge 16 - JT solution.png

ENix
8 - Asteroid
Spoiler

ENix_0-1620650268860.png

 

jtoboyle
6 - Meteoroid
Spoiler
Spoiler: jtoboyle_0-1620791439910.png

 

Here is my solution to Challenge 16.

Thomas_W
8 - Asteroid

Solution attached

Erin
11 - Bolide

Had to look this one up because I am not familiar with embedded new lines --- but I am now! However, question in the spoiler on truncated lines... 

 

Spoiler
Question - I had to add in a select tool before the RegEx that lengthens Field 1 to 254, otherwise I get an error that it is truncated in the RegEx process. However, this doesn't happen when I run the solution. Why? I don't see the difference. 

Challenge 16.PNG
DaisyJones
8 - Asteroid
Spoiler

Challenge 16.png
sonyakasenkramer
8 - Asteroid
Spoiler
sonyakasenkramer_0-1622215121195.png

 

TKSnider
8 - Asteroid

My solution is below