...
- File → Select Individual Record(s) To Make → Display Field 035
- Select all records that contain an 035 field
- Generate Report → Save As .txt (tab delineated)
- Open file in Excel
- Replace all prefixes [ i.e. \\$a(OCoLC) ] with an asterisk (Ctrl H is the keyboard shortcut in Excel)
- Copy column of numbers into a .txt file
- Follow the above instructions for the general process
ISBNs
- Searching by ISBNs will often retrieve many, many hits, and have at least a few errors. This is because eISBNs appear on records for print editions. Several records may also exist for the electronic version, including records cataloged in a language other than English. You will probably want to limit the search to records cataloged in English.
- If you have a spreadsheet with the ISBNs, insert a column before the ISBN column. Fill in this column with ll: (that’s two lowercase Ls). Copy these two columns together, and paste them into Notepad.
- In Notepad, you may need to remove any space between the colon and the ISBN, using Find and Replace. You can copy the space between the two, paste the space into the “Find what” and leave the “Replace with” blank. Then click Replace All. This should delete all the spaces.
- Save the file. I usually name it [vendor][date], in case I need to find it later.
...