Challenge #2: Preparing Delimited Data

[David-Carnes]

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_], "[']$", ""),
    '["]$', ""),
   '^["]', ""),
 "^[']", "")

[RichBirch]

This is how I completed it...

Spoiler

Used Text to Columns, Date Parse and Select tools.

Challenge 2

[mddreeves]

Here's mine:

Spoiler

[ascepkova002]

This is my solution

[qb]

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

[alexo]

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

[ShiftM3]

and another!

Spoiler

[Brad1]

I like mine better than the first ans.