Challenge #2: Preparing Delimited Data

[SrideviB]

here you go.. used RegEx, text to Columns and Formula tools.

Thanks,

Sri

[annangip]

did it using parse tools and date time converter did this with a beginner level knowledge but your way was interesting.

[Johannesm2]

Please see attached for my solution.

Thanks!

Johannes

[MCL]

My attempt

[KyleCollins]

#2 down, although I imagine this was a bit harder with older versions of alteryx. 

[sann0638]

Used Regex to remove the " - sledgehammer to crack a nut? :)

[ChrisTX]

2 down, 142 to go...

[MaddieJ]

First attempt is likely over complicated, but hey, I'm on the board! 143 more to go.

Spoiler

[Jasna_dm]

StripQuotes function in Formula or Multi-Field tool? The second one looks more sustainable.