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

Meteor

Nice quick one.

Highlighted
Meteoroid

I knew I could do this with Data Cleanse, but I wanted to try out Regex for the first time ... and it was not nearly as complicated as I thought it was.

 

Spoiler
challenge_16_photo.JPG
Asteroid

My Solution

Asteroid

The data cleansing tool makes this cake.

Spoiler
Solution-Challenge 016.PNG
Asteroid
 
Asteroid

Wasn't aware of the 'Mon." format for the date parse tool, so had to resort to some manual manipulation.  Also used data cleansing tool instead of regex.

Asteroid

Data Cleanse might be my favorite tool.

Spoiler
Spoiler.PNG
Meteoroid
Spoiler
challenge_16.PNG
Asteroid
Spoiler
challenge16_viveknshah.JPG