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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #16: Parsing Out the New-line Character

Alteryx Partner

Nothing New! Really Learning a lot from these challenges!

I used Regex for this one. Took me a while to figure out the syntax.

Meteoroid

image.png

Asteroid

I used DateTimeParse and Regex_Replace to make this work.  

 

Spoiler

 

challenge16.JPG

 

Alteryx Certified Partner

Here it is !

Asteroid

My solution :) 

Highlighted
Meteoroid

Posting my solution - learned about the RegEx tool for the first time after looking at other's posts. Data Cleaning tool worked for me as well. 

Meteor

Hello,

 

Posting my solution here.

 

Thanks!

Alteryx Partner

Here is my solution:

 

Asteroid