Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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