Mastering Metadata Cleanup in MarcEdit

Cleaning metadata in MarcEdit is a systematic process. It typically begins by "breaking" a .mrc (binary) file into the mnemonic .mrk (text) format, performing batch edits, and then compiling it back into .mrc.

1. Batch Deleting Unwanted Fields

To remove entire tags (like local 9XX fields or vendor-specific 655 tags) across your entire file:

• Path: Tools > Add/Delete Field (Shortcut: F7)
• Example: Removing all 949 local call number fields.
• Action: Enter 949 in the Field box and click Delete Field.

Pro Tip: Use the Preview button first. It’s the best way to ensure you aren't accidentally deleting essential data.

2. Targeted Subfield Editing

Use this when you need to change data within a field, such as stripping proxy prefixes from URLs or fixing punctuation.

Path: Tools > Edit Subfield Data (Shortcut: F9)

Goal	Field / Subfield	Field Data	Replace With
Remove "Electronic book" from 655	655 / a	Electronic book.	(Leave Empty)
Update Proxy Prefix in 856	856 / u	oldproxy.com/	newproxy.com/
Add trailing period to 245	245 / a	([^.])\s*$	$1. (Check Regex)

3. Updating Indicators

Indicators control how data is indexed. A common task is fixing the second indicator in the 245 field to account for "The" or "A".

• Path: Tools > Edit Indicators (Shortcut: F8)
• Example: Changing 050 \4 (Local LC Call Number) to 050 00 (LC assigned by LC).

4. Modernizing with the RDA Helper

The RDA Helper automates the transition from AACR2 to modern RDA standards.

• Path: Tools > RDA Helper
• What it does:
  • Adds 336 (Content), 337 (Media), and 338 (Carrier) fields.
  • Converts abbreviations (e.g., "p." to "pages").
  • Removes the 245 $h [electronic resource] GMD.

5. Global Find/Replace & Regex

For general text cleaning (like fixing typos or removing specific phrases), use Edit > Replace (Ctrl+H). For complex patterns, enable Use Regular Expressions.

Regex Example: To find cases where a subfield $b is missing a leading space, search for ([^\s])\$b and replace with $1 $b.

---

Once your edits are complete, navigate to File > Compile File to save your work back into the .mrc format for your ILS.