Challenge #2: Preparing Delimited Data

[MWiechmann]

Done!

スポイラ

Although I have to admit I only realized after googling that StripQuotes() is a thing. Before that I tried REGEX_Replace and realized Alteryx seemingly does not support escaping quotation marks...

[ThomasHoefer]

スポイラ

 

[ethanwillie]

Looks good

[reubn]

スポイラ

 

[jfissel]

スポイラ

[Jfoss]

Really simple challenge but great to see a different way of solving the question

[Allan3112]

Hello community! Please find attached the file for the solution. I am a beginner so will be continuing to post more :)

To summarise my Approach 

1. Used "Text to Columns" to break into columns. 

2. Renamed the columns 

3. Removed punctuation except for the 'Poem Read Date Column' (will be handled later)

4. Finally used a combination of DateTimeParse and dateTimeFormat to convert the value into the needed output. 

[Dominic_Brady]

My solution!

[holly_jones12]

A good intro to spliting columns and using dateparse

[MonicaRoyal]

スポイラ

I'm learning that there  were many way to solve these challenges, here's mine 🤓