Challenge #2: Preparing Delimited Data

[CP_BU]

Hopefully a simple solution! I split the text string on the commas via text to columns, removed the punctuation using the data cleansing tool, converted the date using the custom format option and, finally, I removed unwanted columns and renamed relevant ones using the select tool.

[Gopisrikanth]

Hi My Solution

[fmilliren]

My solution

[SihanL]

2

[Shivanigupta8]

My attempt...

[Jonathan_Alward]

Completed Challenge! 

Not a lot of data but I would be curious to know which approach is the most efficient at scale?

[etester]

Done

[Axelar]

Solution #2

[victormmichel]

Here is my solution.