Challenge #2: Preparing Delimited Data

[taraspringate]

My solution:

[Brad4Data]

Used Text to Columns, Formulas, and Select tools to transform data.

[Lucatelli]

Please find attached my solution.

[rfroese1]

Here's my solution.

[rburrell]

Completed Challenge Solution

[FredNajjar]

Spoiler

[KGS]

Hi,

I used the following tools to complete the assignment:

1. Text to column - with delimit ","

2. Formula Tool - with the following functions: Replace, Trim and Datetimeparse

3. Select Tool for heading name.

Regards

G

[motaa]

Here is my wf out!

[mmmary17]

Spoiler

A few more tools (Data Cleansing and DateTime), learned about the DATETIMEPARSE formula as another approach!

[MariaDonna]

Here's for my solution. 🙂