This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I was just messing around with this a little and came up with this solution.
Here is my solution:
My solution to this weeks challenge!
Pleased with my results, although your solution is more concise. Nice to know your solution did not match the byte count for the target output either; nice - as in - I am not alone.
Just a simple Text to Columns, and a trim function for this one. I had to double check how to get rid of single quotes (" ' ") and double quotes (' " ') in the trim function.
Here's my solution! Could probably do it with a tool less if I knew regex better!
Here's my solution for this exercice :