On 10/05/10 22:52, Daniel Grobani wrote:
Hi,
I did some work recently extracting data from the marcxml field.
These resources gave me a general idea about the relevant MySQL functions and about XPath, the notation used to extract data from the marcxml field:
http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html http://dev.mysql.com/tech-resources/articles/mysql-5.1-xml.html http://www.w3schools.com/xpath/xpath_syntax.asp
If you specify exactly which MARC tags& subfields you want, I'll see if I can help with a query.
My XPATH (such as it ever was) is rather rusty but playing with the ExtractValue function it seems happy if I select on datafield's attributes or subfield's attributes but not both. So I can extract tag x or subfield y but not subfield y of tag x. Anyone have a better xpath expression. Colin -- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 208 366 1295 (phone) +44 (0) 7759 633626 (mobile) colin.campbell@ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com