Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Convert to .mrk and open in the Editor
  2. File → Select Records to Edit
  3. Display field: 035 and import the file
  4. Select all
  5. Generate Report
    1. Tab delimited report
    2. Naming convention: vendor_deletions_mm-dd-yy_extract.txt
  6. Open file in Excel
    1. Delete the top row (with verbal headings)
    2. 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.)
    3. Select column
    4. Data → Text to Columns
      1. Delimited
      2. Select "semicolon" if it's not already selected
    5. Replace "x" with "ocn"
  7. Create .txt in Notepad named bc_ebldda_deletions 10-4-14.txt
    1. Copy each column from Excel document and Paste
    2. Add additional columns to the bottom of the list
    3. After the first column, you can sort the columns to group all the filled columns at the top. This minimizes blank lines.
    4. Include a note to DSS if there are blank lines in the file.

...