[Koha] Extracting Marc Tag 245b for remainder of title in Access

Chris Cormack chris at bigballofwax.co.nz
Fri May 31 10:34:09 NZST 2013


On 31 May 2013 10:23, BRANNON, CHRISTOPHER <CBRANNON at cdalibrary.org> wrote:
> Hey folks.  I'm trying to build a report in Access (don't ask me why).  I know in Koha, I can use ExtractValue(bi.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]') to get the remainder of the title in the Marc record.  However, ExtractValue isn't a function in Microsoft Access.  Anyone know of an equivalent method for retrieving this piece of information in an Access report?
>

Is the data stored in an xml blob in Access?

(just out of curiousity, I know nothing about Access)

Chris


More information about the Koha mailing list