Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI focused on working on this one using only my own knowledge of Regex and various tools, and less on trying to find the most efficient solution. That said, other than a few weaknesses in the Regex tools where it isn't necessarily future-proofed, I'm satisfied with this.
Solution attached below:
^(\d{7})(.*?)\s(\w{2,4})\s\((\d{4})\)\sCAT:(.*?)\sPUB:(.*?)\s\$(\S+)million,\s\$(\S+)million,\s\$(\S+)million,\s\$(\S+)million,\s\$(\S+)million$
Checking other solutions ... regex tokenize to columns for the $ columns is brilliant! Next time.
Used @johnemery 's video tutorial to help out with the RegEx syntax -- huge help and great practice!