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

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.

MattBenj
9 - Comet

Challenge 2 solution.

TrevorS
Alteryx Alumni (Retired)

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:  ",'