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 #2: Preparing Delimited Data

sharsha315
7 - Meteor

Hi,

   Here is the solution for the Challenge #2: Preparing Delimited Data.

Dante_Healy
6 - Meteoroid

Great fun - thanks!  🙂 

dikshide
7 - Meteor

Here is my solution. I will retry this with advanced formula and regex tool when I am comfortable with them.

 

dikshide_0-1595863172409.png

 

Marc_Schmitz
7 - Meteor

Here is my solution

Will_Condon
7 - Meteor

Will_Condon_0-1595890112598.png

 

KellyJo_
6 - Meteoroid

Here's my solution to the challenge:

JPG
6 - Meteoroid

my answer

KellyJo_
6 - Meteoroid

I am resubmitting my Challenge #2 solution.  I had leading and trailing whitespace, and didn't know what to do with that, so I submitted it with a warning of whitespace yesterday.  Then I saw in my notes that the Data Cleansing Tool can remove whitespace! 🙂

So I fixed that, and now I'm resubmitting my solution, free of warnings. 

 

Kelly

ngindam
7 - Meteor

Thought this was pretty easy but was pleasantly surprised to see a solution with Formula Tool. I used the DateTime tool.

AmrSHOULA
7 - Meteor

Here is my solution. Good challenge...