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

KN82000
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?

fmeo
8 - Asteroid
Spoiler
2. Preparing Delimited Data.PNG
StacyC
6 - Meteoroid
 
Dan_Silva
6 - Meteoroid

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

 

Cheers,

jeng
8 - Asteroid

it just works

KN82000
6 - Meteoroid

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

MichMatt
8 - Asteroid

Challenge 2 solution.

TrevorS
Moderator
Moderator

here is my solution

Community Moderator
Nmetzgen1
8 - Asteroid

solution attached

amenard
6 - Meteoroid

Simply used the parse to columns and select tool. 

 

Delimiters used were:  ",'