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

BS_THE_ANALYST
13 - Pulsar

Used the Data Cleansing tool to remove the line breaks. I'm looking forward to learning Regex to tackle this kind of question. 

Spoiler
BS_THE_ANALYST_1-1672227710756.png

 

kaitlinDS37
8 - Asteroid
Spoiler
kaitlinDS37_0-1672228596490.png

 

flavio-matos
7 - Meteor

My solution

 

Spoiler
flaviomatos_0-1672309814894.png

 

Minsu
7 - Meteor

Here is my solution!

ydevis
8 - Asteroid
Spoiler
ydevis_0-1672392928007.png

 

TyroneW
Alteryx
Alteryx

Solution:

TyroneW_0-1672438308674.png

 

mkreddy
7 - Meteor

I tried to remove new line character using delimiter "\n" and then used the Date-time tool to convert string to date, finally some selection and renaming

mkreddy_0-1672579847185.png

 

mswartzentruber
7 - Meteor

Solved. I used the Data Cleansing tool rather than RegEx. RegEx seems more straightforward.

HannahLaughton
8 - Asteroid

Done!

CammyPhillips
8 - Asteroid
Spoiler
CammyPhillips_0-1673345298809.png