core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Just used 'Text to columns' and 'Formula tool to pars the data in appropriate shape and format :)
Interesting challenge!
Here's my solution!
Here is my solution.
Another one down.
Done. Probably not the best way to do it, but works fine.
my submitted solution.
Used the multi-field formula rather than multiple individual formulae to trim any single/double quotation marks at the beginning and end of each field