• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
For new records and records that are overlayed, we only want to include the 6###7 field if it has a subfield 2 based on a certain string. I set up the following in /abc01/tab/import/oclc_rec.fix:

1 6###7 DELETE-FIELD-COND N,$$2local
1 6###7 DELETE-FIELD-COND N,$$2nasat
1 6###7 DELETE-FIELD-COND N,$$2gsafd

Meaning if the 6xxx7 subfield 2 does not contain 'local', 'nasat' or 'gsafd' then delete the field.

But, as a result, all the 6### fields are deleted, with or without $$2, and with any string in $$2.

Also, if I just specify just one of the above:
1 6###7 DELETE-FIELD-COND N,$$2local

Then only the 6###7's with subfield 2 'local' appear in the record.

Any ideas on how to set this up correctly?

Resolution:
[From Jennifer Murray, SUNY University of Buffalo]:

If you know all the possible values in 6###7 $$2, you can list all the values to delete as follows:
I tried the following setup in /buf01/tab/import/oclc_rec.fix:

1 6###7 DELETE-FIELD-COND Y,$$2aat
1 6###7 DELETE-FIELD-COND Y,$$2bidex
1 6###7 DELETE-FIELD-COND Y,$$2dtict
1 6###7 DELETE-FIELD-COND Y,$$2embne
1 6###7 DELETE-FIELD-COND Y,$$2fmesh
1 6###7 DELETE-FIELD-COND Y,$$2gtt
..etc.

Meaning delete any 6###7 field that has any of those subfield 2 strings.

This setup works as desired.

• Article last edited: 10/8/2013