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
6 - Meteoroid

Solved using Text to Columns, DateTime, Multi-field Formula(using StripQuotes) and select tool for renaming columns.

Has someone found using RegEx to remove double and single quote?

Highlighted
8 - Asteroid
Spoiler
2. Preparing Delimited Data.PNG
Highlighted
6 - Meteoroid
 
Highlighted
Alteryx Partner

Dirty, but super quick. I'm pretty sure you could Regex parse the whole thing in a single pass. 

 

Cheers,

Highlighted
Alteryx Certified Partner

it just works

Highlighted
6 - Meteoroid

Ah thanks but I meant via the reg ex patterns and metacharacters.

Highlighted
8 - Asteroid

Challenge 2 solution.

Highlighted
Moderator
Moderator

here is my solution

Community Moderator
Highlighted
8 - Asteroid

solution attached

Highlighted
6 - Meteoroid

Simply used the parse to columns and select tool. 

 

Delimiters used were:  ",'