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

Zangoly
8 - Asteroid
Spoiler
Zangoly_0-1587123021927.png

 

deepaprash
8 - Asteroid

quick one.

Chiaroscuro
6 - Meteoroid

HI! I'm here to share my solution.

 

I used the common tools:

Data Cleansing Tool - for removing the new-line character

Formula Tool - for formatting the Date

 

Have a nice day! 🙂

Sudha8990AI
8 - Asteroid

This exercise is good

Xeu911
8 - Asteroid

Challenge done, hereby my solution!

Spoiler
crassemusse_0-1587307493169.png

 

AMansour
11 - Bolide

Hello,

Here's my solution

 

Spoiler
Capture d’écran 2020-04-19 à 16.54.48.png

Cheers,

Amr

liamholland
8 - Asteroid

Solution:

Solution Screenshot.png

Brad4Data
Alteryx
Alteryx

RegEx to parse out the new line character, then format fields and rename.  

Varshaa
7 - Meteor

Used Formula tool, RegEx_Replace function. Ran 0.1 seconds faster than the official solution!

 

Challenge 16.PNG

JohanRanschaert
8 - Asteroid

solution in attach