[Wactclc-alma] Extract OCoLC, OCN, or OCM from Network Number

[Guidry, Wade]

This is a follow-up from Tuesday's Leads+ discussion about reporting OCLC numbers out of analytics.

I was just playing around with a more sophisticated formula I found in Alma-L, that extracts OCLC numbers from the network number field, regardless of the OCLC prefix in use (OCoLC, ocn or ocm).

This technique would be useful if you think you have records with ocn, ocm, or on, instead of OCoLC prefixes.

I posted an example report, at:

/shared/community/reports/consortia/wactclc/scratch/ Extract OCoLC, OCN, or OCM from Network Number

The formula itself is kind of cumbersome, but it seems to work:

CASE WHEN UPPER("Bibliographic Details"."Network Number") LIKE '%OCOLC%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."Network Number" FROM LOCATE('(OCOLC',UPPER("Bibliographic Details"."Network Number"))), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."Network Number",'; ') FROM LOCATE('(OCOLC',UPPER("Bibliographic Details"."Network Number"))))),';','') WHEN UPPER("Bibliographic Details"."Network Number") LIKE '%OCM%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."Network Number" FROM LOCATE('OCM',UPPER("Bibliographic Details"."Network Number"))), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."Network Number",'; ') FROM LOCATE('OCM',UPPER("Bibliographic Details"."Network Number"))))),';','') WHEN UPPER("Bibliographic Details"."Network Number") LIKE '%OCN%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."Network Number" FROM LOCATE('OCN',UPPER("Bibliographic Details"."Network Number"))), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."Network Number",'; ') FROM LOCATE('OCN',UPPER("Bibliographic Details"."Network Number"))))),';','') WHEN UPPER("Bibliographic Details"."Network Number") LIKE '%ON%' THEN REPLACE(LEFT(SUBSTRING("Bibliographic Details"."Network Number" FROM LOCATE('ON',UPPER("Bibliographic Details"."Network Number"))), LOCATE(' ', SUBSTRING(CONCAT("Bibliographic Details"."Network Number",'; ') FROM LOCATE('ON',UPPER("Bibliographic Details"."Network Number"))))),';','') ELSE 'No OCLC Number Available' END


[Title: Big Bend Community College Logo]

Wade Guidry
Library Consortium Services Manager
Big Bend Community College
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>

509.760.4474
www.bigbend.edu<http://www.bigbend.edu/>

Big Bend Community College * 7662 Chanute Street NE * Moses Lake, WA 98837-3299


WACTCLC Alma Instance: Alma NA02<http://status.exlibrisgroup.com/>
WACTCLC Primo Instance: Primo NA08<http://status.exlibrisgroup.com/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20180201/ab2d97fa/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 12948 bytes
Desc: image003.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20180201/ab2d97fa/attachment.png>