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
Magnetar

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

Saqueador
BS_THE_ANALYST_1-1672227710756.png

 

kaitlinDS37
Asteroide
Saqueador
kaitlinDS37_0-1672228596490.png

 

flavio-matos
Meteoro

My solution

 

Saqueador
flaviomatos_0-1672309814894.png

 

Minsu
Meteoro

Here is my solution!

ydevis
Asteroide
Saqueador
ydevis_0-1672392928007.png

 

TyroneW
Alteryx Alumni (Retired)

Solution:

TyroneW_0-1672438308674.png

 

mkreddy
Meteoro

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
Meteoro

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

HannahLaughton
Asteroide

Done!

CammyPhillips
Asteroide
Saqueador
CammyPhillips_0-1673345298809.png