Dan,
If it were me, I'd haul the XML file in with a PHP script and use regular expressions to parse out the necessary information. If you don't want to do this in your favourite scripting language, you could try getting the hang of awk, which is very good at this kind of job.
man awk
or, preferably,
info awk
(where available), for more details.
awk is reasonably simple to learn initially, especially if you're already familiar with regex, but a bit of a swine to master.