Challenge #2: Preparing Delimited Data

[Tofel]

スポイラ

[KorkuSep]

Hi,

This is Alex and this is my first weekly challenge post. loving the fun

[eraaz_lala]

Hello, Attached my solution for Challenge # 2

Eraaz

[LukeD]

Hi,

Please find attached my solution to challenge #2.

[Kinga]

hi,

Please find my two versions of solution (almost the same but helped me to understand differences between two tools).

スポイラ

[ivan_duniak30079]

スポイラ

Spoiler!

[daiphuongngo]

Completed

[keynguyen]

スポイラ

Spoiler !

 

[lyon_abido]

I decided to use the Text-to-Column and Formula tools because they are more intuitive. Maybe in the future I'll try using the RegEx tool to optimize the parsing. 

Fun challenge!

[SrikanthSoma]

Completed the task the long way but learned a better way to do the same. 

スポイラ

Instead of using the Formula tool to trim the quotes, I use the text to columns to split the quotes from text and then deselected the quotes. Using the Trim function seems to easier and efficient too.