[Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

[Elena Bianco]

I'm impressed that you remembered that it was in the online meeting notes somewhere. That totally escaped me. Thanks again - so glad I have this group to help me figure stuff out...

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> On Behalf Of Paula Laine
Sent: Wednesday, October 24, 2018 12:41 PM
To: WACTCLC Alma Discussion <wactclc-alma at lists.ctc.edu>
Subject: Re: [Wactclc-alma] analytics question STRIP OUT OCLC NUMBER

I will say that it took me a long time to find that snippet, buried in our online meeting notes.
That'll teach me not to wait next time I need something we have discussed!

                Paula

From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto:wactclc-alma-bounces at lists.ctc.edu>> On Behalf Of Ventura, Gerie
Sent: Wednesday, October 24, 2018 12:36 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

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





From: Wactclc-alma <wactclc-alma-bounces at lists.ctc.edu<mailto: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<mailto: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 01D46B97.31CD7850]
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/d359a009/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/d359a009/attachment-0002.png>