Creating Upload Files for HathiTrust with MarcEdit
Files to be edited: MPM = multi-part monographs (requires subfields 1-4, 5&7 if available)
SPM = single-part monographs (requires subfields 1-4,7 if available)
SER = serials (requires 1-2, 6 if available)
Hathi trust info: https://www.hathitrust.org/print_holdings
Note: It’s always a good idea to make copies of your source files before doing any editing.
- Preparing the SPM file for Processing
Some entries in the SPM file may have duplicate subfields 1, 2, and 7 fields. These need to be removed before processing the file.
- Double-click on the SPM mrc file to open the file in MARC Tools.
- Select MarcBreaker and click the box next to Translate to UTF8, then hit Execute
- Once complete, click on Edit Records
- Click F9 (Edit Subfield Utility)
- In Field enter “960”; in Subfield enter “1”
- Check the box next to Delete Duplicate Subfield
- Repeat for subfields 2 & 7
- From the top pulldown menu, select File=>Compile File into MARC
- When it’s done, close the file and choose “No” when it asks you if you want to save the changes
You’re now ready to proceed with all files.
- Set File Paths
- Open MarcEdit and from the top pulldown menu select Tools=>Export=>Export Tab-delimited Records
- For the first path, browse and select one of the mrc files
- For the second path, browse to the save location and name the text file with the filename structure “okstate_TYPE_YEARMODA”, for example:
- okstate_multi-part_20180828.txt
- okstate_single-part_20180828.txt
- okstate_serial_20180828.txt
- Leave the Select Field Delimiter as: Tab (\t) and the In field delimiter as a comma (,)
- Click on Next

- Define Fields/Subfields to Export
- In Field, type 960
- In Subfield, type 1
- Click Add Field
- Repeat for each subfield, in numerical order, processing files in this order
(you have to re-enter 960 each time you want to add a field, but the program keeps the added fields between exports, so you just have to add/delete rather than build from scratch)
- For MPM: 1-4, 5&7 if available
- For SPM: 1-4, 7 if available
- For SER: 1-2, 6 if available
- Click on Export

- Open the files to review. They will look something like this:






- Delete any initial lines of text with “960” in the resulting file, then save and close.
- You can delete the copies you made of the initial files.