Weekly Challenge

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

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

Submit Feedback
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.

Challenge #2: Preparing Delimited Data

Highlighted
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

 

 

Highlighted
7 - Meteor

This is how I completed it...

 

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

Challenge 2Challenge 2

 

Highlighted
6 - Meteoroid

Here's mine:

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

This is my solution

Highlighted
5 - Atom
 
Highlighted
7 - Meteor

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

 

weekly-2.PNG

Highlighted
Alteryx Partner
 
Highlighted
8 - Asteroid

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

Highlighted
8 - Asteroid

and another!

Spoiler
Challenge#2.png
Highlighted
11 - Bolide

I like mine better than the first ans.