...
- Convert to .mrk and open in the Editor
- File → Select Records to Edit
- Display field: 035 and import the file
- Select all
- Generate Report
- Tab delimited report
- Naming convention: vendor_deletions_mm-dd-yy_extract.txt
- Open file in Excel
- Delete the top row (with verbal headings)
- Replace the following text strings: *\\$a(OCoLC) $z(OCoLC) with ;x (Note: You cannot paste from this document.You either need to copy the texts strings from within the Excel spreadsheet or type them in. Don't include the asterisk before $z.)
- Select column
- Data → Text to Columns
- Delimited
- Select "semicolon" if it's not already selected
- Replace "x" with "ocn"
- Create .txt in Notepad named bc_ebldda_deletions 10-4-14.txt
- Copy each column from Excel document and Paste
- Add additional columns to the bottom of the list
- After the first column, you can sort the columns to group all the filled columns at the top. This minimizes blank lines.
- Include a note to DSS if there are blank lines in the file.
...