Weekly Challenges

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

Also available in | Français | Português | Español | 日本語

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

My solution -

Solution

My solution attached

1. text to columns

2. data cleanse to remove quotation marks

3. parse date time

4. select to rename / drop columns

I learned that the Parse tool

can accept and execute multiple delimiters at once

Please see attached!

Challenge #2: Preparing Delimited Data