We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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_B
Alteryx
Alteryx

Solution attached

Erin
9 - Comet

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