core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Thought I took the long way, but appears on par with the solution.
My Solution.
My solution:
Wasted time trying to do it on Regex while it was quickly done using Text to columns
Fun weekly challenge! 😀👍🏻Table parsing comes up a lot when trying to enhance data ready for machine learning. Definitely useful skill to have!I think I could have done this in a few less tools, so would be interested in revisiting in the future.