Follow
There are many times I wished SQL Server had native T-SQL support for regular expressions.
Without it, I often resort to writing queries that work just good enough for the dataset.
Bullet-proof is almost impossible.
(And, yeah...I'd probably end up pulling my hair out trying to find the magic RegEx pattern matching string. But still.)