in reply to Re: Regex problemin thread Regex problem
I don't think any of really know what your data looks like. That's why you gor different replies - we all tried to solve a different problem.
Can you show us exactly what your data should look like before and after the substitution.