Challenge #2: Preparing Delimited Data

[radu_gabriel]

My solution

[lauramaestuvazquez]

Here you can find my solution. For learning purposes, I propose three alternatives:

• Using the Python tool
• Using the RegEx tool
• Using the Formula tool

[TheOC]

A nice challenge

Spoiler

[TSteadman30]

Very enjoyable!

[rswathi]

My solution

[JMH3]

Nice Challenge

[ainderike]

My solution is attached. Great first challenge!

[ahmedirfanp]

The first challenge I worked on by Myself. The strip quote function came in handy.

[winsarg]

😁My solution was a bit different. Instead of using the formula tool I expanded the parameters of the Text to Columns tool to include " and ' as delimiters instead of just the columns. Then I used a date time tool to fix the date formatting, and a select tool to eliminate unnecessary columns and rename the ones I wanted to keep.

[Uazir]

Nice example.