Re: EUREKA! a way to find repeated MARC fields
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Date: Tue, 17 Apr 2001 10:45:25 -0400
- From: "Laura J. Bowen" <lbowen@xxxxxxxxxx>
- Subject: Re: EUREKA! a way to find repeated MARC fields
Linda, you are beyond compare!
Thank you so much for sharing. This is wonderful.
At 02:15 PM 4/13/01 -0400, you wrote:
>Dear Innopacers far and wide:
>I believe I have found a way to find records in Innovative that have two or
>more instances of the same tag (e.g., records with 2 100 fields, or 2 245
>fields, or two call numbers - regardless of the content) It's not pretty
>but it works.
>Create a list of suspect records, or of a subset of your database if you
>need to work through the whole thing.
>Use Output User Selected Format
>Specify output as the record number and the suspect field tag (usually MARC)
>Specify the "Repeated Field Delimiter" as some character that is unlikely
>to occur in the data itself.
>Output the file to a workstation
>Open the file in Excel
>Use the Excel FIND function to find the repeated field character - e.g. if
>the suspect data is in column C and the delimiter is a semicolon, use the
>Any cell that returns a number has that character in it; sorting by the
>FIND column collects all the suspect record numbers.
>Now in a perfect world we could take that file of record numbers and import
>it to III as a review file.
>PS - I don't read all messages in this list - so perhaps someone has
>already solved this problem. I was pretty excited, though, when I tested
>this and it worked so I had to share it.
>Linda G. Bills Tri-College Library Automation Coordinator
>lbills@xxxxxxxxxx Bryn Mawr, Haverford and Swarthmore Colleges
>(610) 526-5294 Canaday Library, Bryn Mawr College
>(610) 526-7480 fax 101 N. Merion Ave.
> Bryn Mawr, PA 19010
>This message was distributed through the Innovative Users Group INNOPAC list.
>Private replies: Linda Bills <lbills@xxxxxxxxxx>
>Public replies: INNOPAC@xxxxxxxxxx
Gettysburg College Library
This message was distributed through the Innovative Users Group INNOPAC list.
Private replies: "Laura J. Bowen" <lbowen@xxxxxxxxxx>
Public replies: INNOPAC@xxxxxxxxxx