Command to export particular fields from all records

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

Description:
I need a command to export the 022, 050, 082, and 086 fields from all the records in our QRS01 bib library. (I don't have access to the GUI.)

Resolution:
These are the commands in version 20....

First, you need to run p_ret_01 to retrieve the keys of all the records:

csh -f $aleph_proc/p_ret_01 QRS01,,allkeys.js,000000000,999999999,,00,00000000,99999999,00000000,99999999,,AND,NOT,,,,,,,,,,,,,,,,,,,,,,00000000,99999999,MASTER, > & qrs01_p_ret_01.mmdd.log &

(You need to change "allkeys.js" to the name you want the output file with all the keys to have.)

Then, you need to do this:

csh -f $aleph_proc/p_print_03 QRS01,allkeys.js,022##,050##,082##,086##,,,,,print03.outfile,A,,,,N, > & qrs01.p_print_03.mmdd.log &

(You need to change:

allkeys.js to the name of the file produced in the first step and
print03.outfile to the name you want for the output file . )

The "A" will give you Aleph Sequential output. If you want MARC format, it would be "M1"; or, for MARC XML, "X".

• Article last edited: 10/8/2013