Automating scraping of table data to XML
- by thewinchester
Problem
I have a YQL query result that I'm trying to get converted and sort into a clean XML file.
Background
Being the pains that they are, information from the World Cup isn't freely available in an easy to reuse format.
So, after a bit of finessing with YQL I have managed to liberate the required table rows which contain the data I'm after.
The YQL query can be viewed at:
http://query.yahooapis.com/v1/public/yql/ravingbeefsteak/worldcup2010groupliberator?diagnostics=true
I'd like to now convert this information into XML, and being an absolute n00b I don't know where to start or what to look for.
I'm also needing to do a find and replace on the data to get the URL's working as they should without manual changes, and hopefully an initial sorting of the data.
If anyone can point me in the right direction of what I need to be doing to make my needs a reality it would be greatly appreciated.