RE: Create list of records with multiple fields?

[John Dillon <JDillon@xxxxxxxxxx>]

Moira,

We've had some luck doing this on a couple occasions.  To our knowledge
there hasn't been a direct way to search and retrieve records w/ multiple
occurrences of a given field.  Two methods below, assuming there actually is
data in the multiple fields.

Slower manual method:  we'd first create a list of any bibs. having any
occurence of 092 (using the marc field (!092) does not equal (<>)
nothing/blank (enter).  Then we'd List out on that field.  Whether you allow
variable fields to display on the same line, or each on a new line, you can
visually scan that output in a text editor and fairly well see where extra
occurences appear.

Faster method using MS Excel:  take the same list in III, and use the "U >
Output USER-selected format" method of output.  List out on the Record#
field and !902 field.  Under the subsequent Record Format options, set both
the Field Delimiter and especially the Repeated Field Delimiter to Tab.  We
then send the file out and open it in MS Word.  From there we copy and paste
the whole file's data into Excel.  Any multiple occurences of field 902
should fill into the extra or right-most columns, meaning columns C, D, etc.
(Col. A would have the record#, and B the first occurence of 902.)  You can
then also sort Col. C alone in reverse order to bring all of these records
together at the top.  Make sense?  (There's probably a way to skip the Word
step and import directly into Excel, but as described above only takes 2
seconds.)

HTH,

John D.


-----Original Message-----
From: Moira Burke [mailto:mburke@xxxxxxxxxx]
Sent: Tuesday, July 15, 2003 4:27 PM
To: innopac@xxxxxxxxxx
Subject: Create list of records with multiple fields?


Is it possible to create a list of bib records that have more than one of a 
given field?  In our case, we're looking for all the records that have more 
than one MARC 092 field, but can't find a way to do it.  Anyone had any 
luck doing this?

Thanks,
Moira


________________________
Moira Burke
Digital Services Coordinator
Portland Community College Library
mburke@xxxxxxxxxx
(503) 977-8167

--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac