Skip to main content
OCLC Support

How do I extract MARC records from a file using MarcEdit

Symptom
  •  I have a file of records, I want to extract specific a specific record or a subset of records from the file.  
  •   If they have the ISBN/ISSN/OCLC Numbers or the titles of the records they want to extract they can use MARCedit to search large files, batch select the specific records, and send them to a separate file.
Applies to
  • WorldCat Collection Manager
Resolution

If you have the ISBN/ISSN/OCLC Numbers or the titles of the records you want to extract you can use MarcEdit to search the files, batch select the specific records and send them to a separate file.

Details

1.  Create an Excel file that contains information about the titles you are seeking*

3   Import the file of records into MarcEdit** 

4. Import the Excel sheet of titles to run against the .mrc file.  Extract just those matched records to a file.  MarcEdit may default to a .mrk file,  we recommend changing this to a     .mrc file. 

*Create a text file that contains the search strings that you wish to use to select these records.  The file should have one search string per line (no arrow brackets):

<ISBN>

<ISSN>

<THIS IS THE TITLE>

<OCLC NUMBER>

Steps

1   Open MARC edit.

2.  Access Tools > Select MARC Records > Extract Selected Records.

3.  Specify the Source MARC File from which you want to extract the records (the downloaded file)by clicking on the yellow folder and browsing to the file.

4.  Check the search all Record Data option.

5.  Set the Display field to the field you want to display as referenced in the list pane..This defaults to the 245$a but you might want it to be something else depending on your purposes.

6. Click on the Import File button to import the data. (The Excel sheet of titles)

7. Set the Search drop-down to File.

8. Specify the path to the file of search terms you created earlier in the search text box just to the right of the: 

FILE#:

prefix/tag.

9. Click on the Magnifying Glass button to the right of the search field.

10. Click on the Export Selected button to export the records found with your search terms file.

 

Additional information

Download Marc Edit  

**Marc Edit is not owned by OCLC, it is a free utility used by many libraries. 

Page ID
37121