Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolved
6 tools with one RegEx tool and one text to columns tool in my solution....I have to say that this one definitely challenged me! I am not a RegEx expert so this one definitely took some time to figure out. I am in awe of those that were able to do it in fewer tools!!!
A little slapdash but it gets the job done!
Interesting challenge. RegEx helps, but I could only get some to parse before going with another tool.