From the top menu bar, click on Batch -> Holdings by OCLC Numbers -> Browse to the Notepad document.
Open Analytics -> New -> Analysis -> Subject Area = Physical Items
Expand the Physical Item Details folder, choose Lifecycle -> filter by Deleted.
Expand the Item Modification Date folder, choose Item Modification Date -> filter by greater than or between date (depending on last time the report ran).
Expand the Location folder, choose Location Name -> filter is not equal to, and exclude the following locations: Borrowing Resource Sharing Requests and Lending Resource Sharing Requests, also exclude periodical locations.
Expand the Bibliographic Details folder, choose Title. In addition, choose OCLC Control Number (035a).
Note: OCLC numbers are not indexed in Analytics before 2020.
Retrieve OCLC numbers for bibliographic records prior to 2020
Add Network ID four times.
Click on the gear icon next to the Network ID.
Choose Edit formula.
Copy this formula: Evaluate('regexp_substr(%1,''(\(?[oO0][cC]\w+\)?\W?\d+)'', 1,1)',"Bibliographic Details"."Network Number")
Paste into the Column Formula area, replacing “Bibliographic Details.”Network Id.”
In the same window, click on Custom Headings, change the Column Heading to something that makes sense to you.
OCLC numbers do not always appear in the first 035 to retrieve further OCLC, paste the formula into the next Network Id field. Evaluate('regexp_substr(%1,''(\(?[oO0][cC]\w+\)?\W?\d+)'', 1,2)',"Bibliographic Details"."Network Number"). Change the second 1 to 2, next field 3 and so on.
Click over to the Results tab to see the output.
From the Results tab, download the results to Excel.