RE: INNOPAC digest, Vol 1 #935 - 22 msgs

["Akram Zouroufchi" <azourouf@xxxxxxxxxx>]

Hi John,

To eliminate using word, after you set both the Field Delimiter and
especially the Repeated Field Delimiter to Tab, you will need to ftp it
in order to file it out.  At this time instead of giving file .out as
extension give the file .xls extension and you should be able to open it
in Excel directly.

I hope this help.

Akram Z.

=====================
From: John Dillon <JDillon@xxxxxxxxxx>
To: "'innopac@xxxxxxxxxx'" <innopac@xxxxxxxxxx>
Subject: RE: Create list of records with multiple fields?
Date: Wed, 16 Jul 2003 17:31:11 -0400
Reply-To: innopac@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.