Why did you abandon the XML approach? It performs better than manipulating the strings.

I did notice that the sample XML data you provided does not match the case of the fields in your "solution". XML is case-sensitive, so the cases need to match.

Drew