Skip to Main Content

University Library, University of Illinois at Urbana-Champaign

MarcEdit

An introduction to the MARC record editing software MarcEdit

Editing Field Data

This function is designed to allow users to directly edit data for a particular field, though it does not automatically take into account subfields unless specifically identified in the query. To edit subfields within a field, see Editing Subfield Data

  1. Open the .mrk file by selecting it in the folder, which should open the file in MarcEditor, or open MarcEditor from the MarcEdit home screen and select the file in File->Open. 
  2. Each datafield will be indicated by “=XXX” notation, which is fully searchable within MarcEditor. This allows users to perform very specific functions using regular expressions, but it is worth remembering when searching the document.
  3. To find and replace data within fields in a batch of records, go to Tools > Edit Field Data, as below:

          

  1. You should see the following dialog box:

                     
First select the field you would like to search and replace from the dropdown menu or keying it in manually. Then enter the text you would like to search or the regular expression you would like to use for the search. If “Match Case” is selected MarcEdit will be case-sensitive when performing the search. If you are searching with regular expressions, be sure “Use Regular Expressions” is checked. When you are finished, the dialog box should look something like this:

  1. Click Process. MarcEdit will tell you how many modifications were made within the document. The results of the transformation I performed can be seen here: 

                            

  1. You will notice that the data was added to the field specified, not the subfield. For information on adding and editing subfields, see Editing Subfield Data

You can also enter the subfield using the $[subfieldcode] notation and MarcEdit will add it to the entered datafield.

  1. To convert this edited record back into a MARC record from the Mnemonic format, you can press the icon from the toolbar shown below.

             

  1. You will be prompted to give the compiled record a name, as the creator of MarcEdit tends to favor the creation of duplicates rather than regularly modifying the same record. 

Swapping Data Between Fields

This functionality provides a simple way to shift specific data within one datafield into another datafield or copy data from one field into another. This function allows for greater granularity in what data is moved and allows users to specify that the copied data be stored in a field with particular indicators or subfields. The Copying Field Data function above is designed primarily to move data along with subfield and indicator information into a new field, while this function is better suited to taking data from one field and putting into a field which may have different indicators or subfields.

  1. Open the .mrk file by selecting it in the folder, which should open the file in MarcEditor, or open MarcEditor from the MarcEdit home screen and select the file in File > Open.
  2. Select Tools > Swap Field Data
  3. A dialog box should appear:

      

 The “Original Data” line specifies which field you would like to copy the data from while the “Modified Data” line indicates which field you would like to move or swap the data into.

When entering data for the field you would like to copy, be sure to include the indicator and subfield data. This also applies to the data field you would like to copy the data into. If this information is not entered, MarcEdit will not be able to copy the data or place it in the desired field.

  1. Next select the sort settings. Below is a table outlining the general result if each box is checked:

Option

Definition

Copy Source

The data from the original field will be kept as well as added to the modified field.

Add to Existing Field

Adds the information only to records which have the field specified in Modified Field. Note: MarcEdit will add the data specified by Original Data to every field if that field is repeatable. Ex: if a 740 field is selected under Modified Data, each instance of the 740 will contain the copied data.

Add to Existing/Create New

Adds the data from specified field to every record, appending it to an existing field if one exists or creating a new one if one is not present in the record. This record will also apply the copied data to each instance of a repeatable field. 

Process One Field Per Swap

This box will add one instance from the specified Original Data field to one instance of the Modified Data field. If this is not checked, MarcEdit will add each instance of a (possibly) repeatable datafield to each instance of the Modified Data field rather than only swapping one instance of the original data field.

Sort Modified Field

This sorts the modified datafield within the record after the swap has occurred.

  1. When you are finished, the screen should something like this, depending on preferences:

Note that if both Find fields are left blank, it will search and swap everything in the specified fields. Use a regular expression to more precisely add data to the specified field and be sure “Treat as Regular Expression” is checked.

 

  1. Click Process. MarcEdit will perform the specified swap. The results of the above function can be found below:  

                        

Notice that the indicator data and subfield data are not the same as in the original field. This is the result of the particular transformation specified in the example, though it would not be possible were the Copying Field Data function instead.

  1. Should you want to undo it, click Edit > Special Undo.
  2. To convert this edited record back into a MARC record, select File > Compile File to MARC

Copying Field Data

This function allows you to move data from one datafield to another. It is similar to the Swap Data field, only it will simply move data from one field to another rather than switching fields in their entirety.

  1. Open the .mrk file by selecting it in the folder, which should open the file in MarcEditor, or open MarcEditor from the MarcEdit home screen and select the file in File > Open.
  2. Each datafield will be indicated by “=XXX” notation, which is fully searchable within MarcEditor.
  3. Select Edit > Copy Field. This dialog box should appear:

                        

The source field will be the field that the data will be copied from. Since it does not allow for you to specify subfields or indicators, it may be easier to use the Swapping Data Between Fields tool also listed on this page if you only want to move certain subfields to a new field. The Copying Field Data works well if you are simply looking to create a new field from an existing field. If there are more than one instances of a particular field and you would like to copy just one of them, utilize the “Find in Field” box to specify this field. An example of this kind of search using a regular expression can be found below: When you have entered the search data, the dialog box should look like this:

                     

This search will find an 035 field which has the string “(OCoLC)ocm” and copy anything after that string into a 999$a field. If the “Find in Field” box were left blank, MarcEdit would create a 999$a field for each 035 field present in the record. Click Copy when you are ready.
The results of the action specified above can be seen below:

As you can see, the indicator and subfield data has been migrated to the new field as well.

  1. To undo the result of this transformation, select Edit > Special Undo.
  2. To compile the record back into MARC, select File > Compile File to MARC