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

dharini
8 - Asteroid

Here is my solution

kat
12 - Quasar
Spoiler
Challenge #16.PNG
Carlithian
11 - Bolide
11 - Bolide

Heres my solution

AidanBramel
8 - Asteroid

My solution, can't imagine it's different than most of the rest. :)

Lee_Gibbons
7 - Meteor

Solution Attached :D

gmartin
7 - Meteor

Here is my solution!

 

Spoiler
challenge_16_gm_image.PNG

challenge_16_gm_image.PNG

tammybrown_tds
8 - Asteroid

I hope the fact that this one was easy is a sign that I am getting more comfortable with the tools!

pasccout
8 - Asteroid

Here is my solution...

 

Although... the output from the start file show \n replaced by nothing... the object does replace it with a space...

TimothyB
6 - Meteoroid

My Solution Data Cleanse, Formula to parse and re organize date string, Selection to drop a column and Format V_String to Date

Spoiler
Formula to rearrange date string: "20"+Right([Field_3], 2)+ "-" + IF (Right(Left([Field_3], 6),3))="JUN" THEN "06" ELSEIF (Right(Left([Field_3], 6),3))="DEC" THEN "12" ELSE "" ENDIF + "-" + Left([Field_3], 2)
Note: can easily add to ELSEIF statement to map all 3 Character Month String Values
wk16 (2).png
Vinutha
8 - Asteroid

This one was fun. Love using RegEx; loads to learn about this tool.