It took me quite a lot of time to do this one. Was trying to match through the company name position between blanks/nulls, but that was all very inconsistent. Finally gave up and did it with regex as everyone else.
A beautiful example of why Regex is the best thing since Otto Frederick Rohwedder embraced his powerful laziness and made an paralleled contribution to society.
I suspect my solution differs slightly to most in form if not logic:
Regex makes me happy.