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

[Michaela Brenner <mbrenner@xxxxxxxxxx>]

John,

I export the file ("U") and set the Field Delimiter and
Repeated Field Delimiter from RECORD FORMAT to ASCII
character <tab>. Then you can just open it in Excel as
tab-delimited file. Works fine here.

Michaela

--On Wednesday, July 16, 2003 3:50 PM -0700 Akram
Zouroufchi <azourouf@xxxxxxxxxx> wrote:

> 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.
> 
> --
> 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
>