Want to get involved? We're always looking for ideas and content for Weekly Challenges.
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?
Dirty, but super quick. I'm pretty sure you could Regex parse the whole thing in a single pass.
it just works
Ah thanks but I meant via the reg ex patterns and metacharacters.
Challenge 2 solution.
here is my solution
Simply used the parse to columns and select tool.
Delimiters used were: ",'