We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #2: Preparing Delimited Data

David-Carnes
11 - Bolide

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.

ShiftM3
8 - Asteroid

and another!

Spoiler
Challenge#2.png
Brad1
11 - Bolide

I like mine better than the first ans.