Challenge #2: Preparing Delimited Data

[rkavanagh006]

スポイラ

[DataTester]

Solution for Challenge #2

[sarahjohnson]

スポイラ

[Kong]

Keep going the challenges.  Challenge #2 completed.

[rslopez2]

スポイラ

[madeleineK]

Here my solution!

[data-ninja]

スポイラ

SPOILER

[jstokes1994]

スポイラ

[aihnen]

First weekly challenge complete! Started with Text To Columns to parse by comma, single quotes, and double quotes. Then converted date field to correct data type and renamed using DateTime. Then used Select to separate out the columns I needed and rename/change datatype of Poem_ID field.