/
Command Type Fields (Global Update)

Command Type Fields (Global Update)

Global Update is a very powerful tool that enables many types of edits.  Using Global Update incorrectly can make far-reaching, unintended changes in your organization's database.  You might want to consider this when authorizing staff for the Global Update function.

Table of Contents

Creating Commands for Changing Records

Commands specify the updates, such as edits or deletions, to make in records. When you create a list of commands on the Command input tab, the system applies the entire list of commands to the selected records after you choose Process in the Preview tab.

The next section will review the Choose Command Type choices.

Top of page

Change Variable-Length Field

  • Using the data you enter in the Find data fields, Global Update locates all of the selected records that contain the specified tag, indicators, and data, and replaces the corresponding data in those records with the tag, indicators, and data you specify in the Replace data fields.

  • Find

In the Find text boxes, enter the Field Group Tag, MARC Tag, Ind 1 and/or Ind2 (indicators), and Data you want to change. The system updates only the fields in the selected records that meet all of the specified criteria.

  • Replace

In the Replace data fields, enter the Field Group Tag, MARC Tag, Ind 1 and/or Ind 2 (indicators), and Data you want to replace. The system makes no change to fields with the default value of <no change>.

  • You can delete all or a portion of the variable-length field data by leaving the Replace Data field blank. The system deletes the field or subfield you entered in the Find Data field. Note that you must enter data in the Find Data field. You cannot search for "existence of a subfield" without specifying contents.

  • Choose the Use Displayed Field, Match Case, Match Whole Field, and Match Whole Subfield checkboxes as desired.

  • After specifying the Find and Replace data, choose OK to close the dialog box and return to the Command input tab. The command you created appears as a single line, for example:

  • In the example above, Global Update identifies all records that have a 650 field, with indicators '<blank>' and '0', containing the data "Music|xTheory" and changes that data to "Music theory." The '.' at the beginning of the command indicates there was no specified field group tag. The '/c' at the end of the command indicates that target records must match the case of the Find data, "Music|xTheory". 

Top of page

Delete Variable-Length Field

  • Using the data you enter, Global Update finds all occurrences of the specified tag, indicators, and data, and then deletes those entire fields.  If you only want to delete some data from a field, use Change Variable-length Field.

  • Delete

In the Delete text boxes, enter the Field Group Tag, MARC Tag, indicators, and Data that define the fields you want to delete. The system deletes only the fields in the selected records that meet all of the specified criteria.

 

  • The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (Delete = delete variable-length field.) The Action column indicates the target data criteria and the data to delete in the format target criteria ==> delete data. MARC tags appear in parentheses and indicators appear in brackets.  A wildcard character or word, such as a period ('.'), an equal sign ('='), or <any>, may represent some data fields with unspecified (default) content.  

Top of page

Insert Variable-Length Field

  • Global Update inserts a new variable-length field with the data you enter into each of the selected records.

Insert

  • To insert a MARC field, select (check) the MARC Field check box. To insert a non-MARC field, clear (uncheck) MARC Field, disabling the MARC Tag, Ind1, and Ind2 text boxes.

  • Enter the Field Group Tag, MARC Tag, Ind1 and/or Ind2 (indicators), and Data you want to insert into the selected records. If you leave the default value of <auto select> in the Field Group Tag text box, Global Update automatically assigns a field group tag based on the MARC tag you enter.

  • After specifying the data to insert, choose OK to close the dialog box and return to the Command input tab. The command you created appears as a single line, for example:

The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (Insert = Insert variable-length field.) The Action column indicates the data for insertion. MARC tags appear in parentheses and indicators appear in brackets. A wildcard character or word, such as a period ('.'), an equal sign ('='), or <any>, may represent some data fields with unspecified (default) content.

In the example above, Global Update adds a MARC 590 field with two blank indicators to the records and inserts the data "Keep on holiday shelf until 12/31/00." The 'n' at the beginning of the command reflects the specified field group tag 'n'. 

Top of page

Change Fixed-Length Field

  • Global Update uses your entries to change data in fixed-length fields. Default data appears in the Fixed-length field and Find text boxes.

  • Default data appears in the Fixed-length field and Find text boxes. You can leave the default values or choose new values for these fields. To choose new values, enter the value you want or select one from the list that appears when you begin typing. Alternatively, double-click a field to select from a button grid of valid values for that field. Click the button labeled with the value you want, or type the grid number appearing in the upper left corner of the button, and then choose OK.

To change fixed-length field codes:

  • Specify a Fixed-length field. The record types you selected in the Select records tab determine the default value.

  • Enter a Find value. Select (check) the Validate field check box to force validation of the Find value. Clear (uncheck) this check box to allow entry of any value.

  • Enter a Replace value. The system accepts only valid codes in this field.

  • After specifying the data to change, choose OK to close the dialog box and return to the Command input tab. The command you created appears as a single line, for example:

  • The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (Fixed = Change fixed-length field.) The Action column indicates the target field and the replacement value in the format old data ==> new data. A wildcard character or word, such as a period ('.'), an equal sign ('='), or <any>, may represent some data fields with unspecified (default) content.

    In the example above, the system changes all values found in the BCODE3 field to the new value 'd'. 

Top of page

Change Special Field

  • Global Update uses your entries to change data in the special MARC 006, 007, and 008 fields.

  • The Change special field option appears in the Choose Command Type dialog box only if the record types checked in the Select records tab include Bibliographic, or Authorities, or Checkin.

  • Default data appears in the Record Type, MARC Tag, Format, Element, and Find fields. You can leave the default values or choose new values for these fields. To choose new values, enter the value you want or select one from the list that appears when you begin typing. Alternatively, double-click a field to select from a button grid of valid values for that field. Click the button labeled with the value you want, or type the grid number appearing in the upper left corner of the button, and then choose OK.

To change special field data:

  • Specify a Record Type. The record types you selected in the Select records tab determine the valid options.

  • Enter a MARC Tag. The tag you enter determines the options appearing in the Format field.

  • Enter a Format. The format you enter determines the options appearing in the Element field. Leaving the default value of <all> retrieves all elements for all formats in the Element field.

  • Enter an Element. Global Update identifies Element values by both their byte number within the MARC field and their name, for example, 15 Country. For 008 field data in the record leader, an 'L' precedes the byte number, for example, REC TYPE=L06.

  • Enter a Find value. The default value of <any> renders all values in the selected field valid for change. Select (check) the Validate field check box to force validation of the Find value. Clear (uncheck) this check box to allow entry of any value.

  • Enter a Replace value. The system accepts only valid codes in this field.

  • After specifying the data to change, choose OK to close the dialog box and return to the Command input tab. The command you created appears as a single line, for example:

  • The command row includes a Command column and an Action column. The Command column indicates the type of command you specified. (Special = Change special field.) The Action column indicates the target field and the replacement value in the format old data ==> new data. A wildcard character or word, such as a period ('.'), an equal sign ('='), or <any>, may represent some data fields with unspecified (default) content.

  • In the example above, the system identifies bibliographic records ('b') with an 008 MARC tag ('008') indicating the format Books ('a, m') with a Country value 'ir' and changes the Country value to 'ie'. 

Top of page

Delete Duplicate Field

  • Using the data you enter in this dialog box, Global Update finds any fields containing the specified data and deletes all occurrences of duplicates. The system defines a duplicate as having an identical MARC tag, indicators, and data.

To delete duplicate variable-length fields:

  • Enter a field group tag, MARC tag, indicators, and data. The system deletes only the fields in the selected records that meet all of the specified criteria.