Challenge #2: Preparing Delimited Data

[seven]

Spoiler

[Hobbs1292]

Here's my solution to Week 2. Thanks, Will

[darrenyoder]

I did a text to columns, a couple RegEx functions, and a date conversion. Didn't seem like the most efficient but it worked!

[Niklas]

Solution attached

[sbuday3]

Attached is my solution.

[FRANCK_ROUQUETTE]

Thank you for the exercice

[SHEZ2161]

This is my first challenge completed, i am working with @mceleavey

Spoiler

first i used text to columns to separate the text into the required columns on the comma. I also used a browse function so I could check my workflow   as I went along. I then used a select tool to get rid of the unwanted text field. After that I used data cleansing to get rid of the quotation marks. Then i used replace to replace the remaining the speech marks. Finally i converting the date into the required format and added another browse to make sure it all works 

[mceleavey]

Well done @SHEZ2161 .

First of many!

M.