Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThe first challenge I worked on by Myself. The strip quote function came in handy.
😁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.