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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #16: Parsing Out the New-line Character

Atom

Here is my solution. 

Meteor
Spoiler

2 Ways have been used to remove embedded new line:

  1. Text to Column by "\n" and then use formula to add the fields together
  2. Use formula "Regex_Replace([Field_1], "\n", " ")"

 

Meteor

Solution attached!

Alteryx Certified Partner

Nice with a beginner challenge again, now my faith in myself has been restored 😂

 

It was nice for once to come back to a simple challenge, that I could solve by my own.

Spoiler

 Seems afterwards, that my approach wasn't that much different that the provided solution, so I am just happy to be on the right path

Br

/Thomas 

Asteroid

Hi,

 

My solution is below. It took me a second to realize why my date-time tool wasn't working but nice challenge.

 

V

 

Spoiler
Challenge 16 - capture.PNG
Meteor

Quick and easy challenge!

Alteryx Partner
Spoiler
image.png
Asteroid

I used RegEx and DateTime.

 

Happy Practice :)

Alteryx Certified Partner
Alteryx Certified Partner

Challenge #16, done.

Spoiler
Challenge16.PNG

Cheers,

Alteryx Partner

Hi,

 

Uploaded the solution.

 

Best Regards,

Sharath Kumar Gurram.