Challenge #2: Preparing Delimited Data

[jbotbyl]

Spoiler

Completed #2 

Completed #2

[StuK]

Solution attached

[MarielJinang14]

Spoiler

Hi! Didn't know the formula used in the solution so I used a different one. Thanks for the solution, learned a new formula. 

-Mariel

[cneivam]

Hello all,

Starting doing my Weekly Challenges, I´m a very big fan of Alteryx!

See you!

Neivam

[kenhermosura]

Solution attached

[steven4320555]

Takeaways: two functions, namely, StripQuotes, and Trim. It feels to me stripquotes function is a simplifed trim function, which is used for quotes.

Again, I have used a not so smart method. but good to try out the text input tool, and find-replace tool.

Spoiler

[ankitasingh]

Hello - My solution using Parsing tools.

[ankitasingh]

Hello - My solution using

Spoiler

Parsing tools

.

[Haroonanalytics]

Spoiler

Spoiler

I used Parse tools; Text to column & DateTime along with the select tool.

Regards,

[TSP]

Another good challenge. 

Solution below.

Tim

Spoiler

SPOILER