How to remove trailing blanks from 008?

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

Desired Outcome Goal:
Field 008 has 10 trailing characters “^” at the end of the field which shall be removed. They came into the field by mistake during data loading.

Field content looks like …
870227c19839999hk^mr^p^^^^^^^0uuu^0fre^d^^^^^^^^^^
… but should look this way …
870227c19839999hk^mr^p^^^^^^^0uuu^0fre^d

The last entry in the field is always “d”. A file with affected system numbers is available.

Procedure:
Run “Download Machine-Readable Records (print-03)” for the file with the affected system numbers and extract only field 008. You get an output file which looks like …
000005678 008 L 870227c19839999hk^mr^p^^^^^^^0uuu^0fre^d^^^^^^^^^^
000053886 008 L 870227c19839999hk^mr^p^^^^^^^0uuu^0fre^d^^^^^^^^^^
000006091 008 L 751101c19559999fr^ar^p^^a^^^^0uuub0fre^d^^^^^^^^^^
000054162 008 L 751101c19559999fr^ar^p^^a^^^^0uuub0fre^d^^^^^^^^^^

Now perform the following vi command …
:1,$s/d^^^^^^^^^^/d/g
… and save the file. It can then be used for loading the fields back using “Load ALEPH Sequential MARC Records (manage-18)” with options “Update current records in the database” and “Replace fields within a record”.

Category: Cataloging (500)

Subject: Importing records (500)

• Article last edited: 10/8/2013