While that is one way to do it, the OP doesn't have pipe-delimited data. They have the format shown, and that seems to be what they must work with.
It is possible to convert it into pipe-delimited, but then we'd be back where we are now. ;-)

~Thomas~ 

"Excuse me for butting in, but I'm interrupt-driven..."