Challenge #2: Preparing Delimited Data

[greegotr]

Solved! Thank you for these challenges.

[hardikkanabar]

Challenge Solved, used tools Text to Col, Data Cleansing, Date Parse and Select tool.

[razconst]

Solved using tools: Text to columns, Data Cleanse, Date Time Convert, Select. 

[joeoswald614]

Spoiler

Used text to columns to split to 3 columns
Data Cleansing to remove punctuation from 1
DateTime to convert 3 to Date
Select Tool to rename key fields and eliminate extra fields

A fun challenge!

[anay_zinje]

Solved, 

Used text to column, data cleansing and select tools to solve this challenge. 

[Vas2665]

use Text to column - Data cleansing - date time - select tool

[Anand_Parekar]

Happy to Solve!

[rchaidez]

Solved using the following tools: Text To Columns, Data Cleansing, DateTime and Select.

[Tanbir89S]

Solved! Solved!

Steps to be followed - 

• Text To Columns 
• Data Cleansing  - Unselect (2) and (3), Check Punctuation additionally with the default selection.
• Date Time - Custom - "dd-Mon-yy"
• Select Tool - Check (1), (2) and (Date Time Out) and rename it to respective column Names 

Here you go.

[Aayushah]

Enjoyed doing this!