Extracting Marc Tag 245b for remainder of title in Access
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? Christopher Brannon Coeur d'Alene Public Library
On 31 May 2013 10:23, BRANNON, CHRISTOPHER <CBRANNON@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
Hi, On Thu, May 30, 2013 at 3:23 PM, BRANNON, CHRISTOPHER <CBRANNON@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?
If you're using Access as an ODBC front-end to the MySQL database, it should be possible to define an "SQL pass-through query" [1] that would let you use the MySQL version of the query directly, ExtractValue() and all. [1] http://support.microsoft.com/kb/303968 Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
That is awesome. Didn't know about that. Works like a charm. Now I just need to figure out the equivalent of HAVING items.holdingbranch=<<Branch filled at|branches>> within Access and all will be well. Thanks for the info! Christopher Brannon Coeur d'Alene Public Library If you're using Access as an ODBC front-end to the MySQL database, it should be possible to define an "SQL pass-through query" [1] that would let you use the MySQL version of the query directly, ExtractValue() and all. [1] http://support.microsoft.com/kb/303968 Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org
participants (3)
-
BRANNON, CHRISTOPHER -
Chris Cormack -
Galen Charlton