Thanks so much, Caroline! Good excuse to brush up on my French. Have used MarcEdit before, but not for this, so your instructions will be vachement utiles :-)
Btw, we've been using the report below to identify which records have issues w/ the 008/33. However, the ExtractValue statement is pulling spaces rather than the actual values. Would be grateful for any suggestions on why the SUBSTRING & ExtractValue statements don't appear to be working well together. All best, Cab Vinton, Director Plaistow Public Library SELECT SUBSTRING(ExtractValue(metadata,'//controlfield[@tag=008]'),33,1) AS LitForm, i.itemcallnumber, i.itype, i.ccode, CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=', biblionumber, '\">', biblionumber, '</a>' ) AS bibnumber FROM biblio_metadata LEFT JOIN items i USING (biblionumber) ORDER BY i.biblionumber DESC, i.itemcallnumber _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha