Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI did a text to columns, a couple RegEx functions, and a date conversion. Didn't seem like the most efficient but it worked!
This is my first challenge completed, i am working with @mceleavey
first i used text to columns to separate the text into the required columns on the comma. I also used a browse function so I could check my workflow as I went along. I then used a select tool to get rid of the unwanted text field. After that I used data cleansing to get rid of the quotation marks. Then i used replace to replace the remaining the speech marks. Finally i converting the date into the required format and added another browse to make sure it all works