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

OK, the data is actually delimited with commas but what is needed is the deletion of single and double quotes that may or may not be present at the start and end of each datum.  A blanket Replace to get rid of quotes would be heavy handed, e.g I don't like green eggs would be rendered as I dont like green eggs.

 

Solution contained in spoiler.

 

 

Spoiler
Regex_Replace(
  Regex_Replace(
    Regex_Replace(
      Regex_Replace([_CurrentField_], "[']$", ""),
    '["]$', ""),
   '^["]', ""),
 "^[']", "")



002.png

 

 

Meteoroid

This is how I completed it...

 

Spoiler
Used Text to Columns, Date Parse and Select tools.

challenge_2_start_file - RB completed.jpgChallenge 2

 

Meteoroid

Here's mine:

 

Spoiler
Capture.PNG
Asteroid

This is my solution

Atom
 
Meteor

Hello! This is my first weekly challenge submission (and first post, period!):

 

weekly-2.PNG

Alteryx Partner
 
Asteroid

This was fairly straightforward - text to columns to split, trim the quotes, then cleanup.

Asteroid

and another!

Spoiler
Challenge#2.png
Bolide

I like mine better than the first ans.