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

David-Carnes
12 - Quasar

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

 

 

RichBirch
7 - Meteor

This is how I completed it...

 

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

Challenge 2Challenge 2

 

mddreeves
6 - Meteoroid

Here's mine:

 

Spoiler
Capture.PNG
ascepkova002
8 - Asteroid

This is my solution

Jamshed
5 - Atom
 
qb
7 - Meteor

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

 

weekly-2.PNG

AndrewBanh
9 - Comet
 
alexo
8 - Asteroid

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

RotesDB
8 - Asteroid

and another!

Spoiler
Challenge#2.png
Brad1
11 - Bolide

I like mine better than the first ans.