Some advice you can apply to your text processing needs:
When in doubt, add another 50 lines of regular expressions…
Really. I’m serious. Any text processing problem can be solved by adding in more regular expressions to your code.
It may be ugly, you may be laughed at and looked down upon, but at the end of the day, when your text is cleaner, and it’s all sitting in MySQL nice and proper, you’ll be the one looking down on those who poo-poo adding in 50 lines of (completely ridiculous) regular expressions…
Mark my words… I know of what I speak!