Challenge #2: Preparing Delimited Data

[edgarl]

Spoiler

[Per]

My shot

Spoiler

[mikeprice17]

Text to columns based on the comma, convert the date, and rename columns.

[Mitrea32]

Solution

Spoiler

First text-to-column to separate by comma delimiter, then data cleansing to remove extraneous punctuation, then DateTime to convert into the proper date format and finally a Select tool to rename the columns

 

[rachelglascock]

Spoiler

Solved this problem! See below with annotations:

[dholle1958A]

Challenge 2 completed

[chrisrayner]

Complete

[AngelosPachis]

My solution