You're fixing the wrong problem. The problem here is that you have several pieces of information in one field violating first normal form. Fix the problem at the source rather than trying to kludge together a fix for something that shouldn't be a problem in the first place.
J. Drew Allen
Business Intelligence Analyst