Re: EUREKA! a way to find repeated MARC fields

["Laura J. Bowen" <lbowen@xxxxxxxxxx>]

Linda, you are beyond compare! 
Thank you so much for sharing. This is wonderful. 

Laura

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
>formula:  =FIND(";",C2,1)
>
>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.
>
>Linda
>
>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
>Archives:  http://innopacusers.org/list/archives/
>
Laura Bowen
Systems Librarian
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
Archives:  http://innopacusers.org/list/archives/