[Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

[Ventura, Gerie]

Have we started a central place where we can share procedures?  Gerie





From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu> On Behalf Of Elena Bianco
Sent: October 24, 2018 12:34 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

Holy cow, Paula! That string is unbelievable and I never would have figured it out in a million years. Thanks very much! Question: Where did you put that in the query?

Elena Bianco, Systems & Technical Services Librarian
Skagit Valley College
2405 E. College Way
Mount Vernon, WA 98273
(360)416-7624

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Paula Laine
Sent: Wednesday, October 24, 2018 12:16 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: Re: [Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

Elena,

Here is a snippet of code that was posted to the list that strips out the OCLC number from the "network number" field.
It looks awful but it works.

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

The rest of it looks like this: [super wide cut&paste]
[cid:image001.png at 01D46B96.2B8267E0]
Feel free to call me if you'd like.

Paula Laine
425-564-2259

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Elena Bianco
Sent: Wednesday, October 24, 2018 11:56 AM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu<mailto:wactclc-alma at lists.ctc.edu>>
Subject: [Wactclc-alma] analytics question

I am trying to run a list of all of the things that we have deleted from Alma in the past year, and I'm realizing that the OCLC numbers are not showing up. We need that so we can do a batch delete in OCLC. I thought that the field Bibliographic ID field would be the one to choose, but this field is blank for a lot of them.

How does one do a search in Analytics and specify that the 035 field be one of the fields that displays - or can you not do that in Analytics? In Millennium, we used to be able to specify which MARC fields to display in any lists that we ran...

Thanks,

Elena

Elena Bianco, Systems & Technical Services Librarian
Skagit Valley College
2405 E. College Way
Mount Vernon, WA 98273
(360)416-7624

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20181024/151d7e88/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 23832 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20181024/151d7e88/attachment-0002.png>