This format is maddeningly close to XML. I would suggest running a regex to to turn it into real XML and then using XML tools to parse it. Try something like s~<UserID>(\d+)</UserID>~</record><record UserID="$1">~g; Then lop off the first </record> and add an enclosing tag for the entire set and you should have real XML.