Re: [IUG] Create Lists question

["Laurie J. Shedrick" <lshedrick at midhudson dot org>]

You could export the name field from the file to excel and then delimit by
the repeated field delimiter, which would put the two extra names into a new
column.  Then sort by that column to bring the names to the top of list.

Laurie J. Shedrick
Automated Systems Manager
Mid-Hudson Library System
103 Market Street
Poughkeepsie, NY 12601
lshedrick at midhudson dot org
(845) 471-6060 X 21


-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Sue Whitehead
Sent: Sunday, June 29, 2008 8:15 PM
To: IUG INNOPAC List
Subject: [IUG] Create Lists question

I need to track down a data entry error, but don't know if I can use
Create Lists for this,

or otherwise how to find the error.  All suggestions are welcome!

I use Create Lists to make a list of current patrons.  When I sort it by
patron name,

the total number of patrons increases by 2.  If I dedup the file, it goes
back to the original

count.

I suspect that I have 2 patron records which each have two "name" fields. 
But I don't know

how to find those two records among the thousands in the file.  Does
anyone have any 

ideas how to find those two records?

I know how to search the original file using the "review" file process in
order to find a subset

of the original file.  I just don't know if Create Lists has a way to
indicate that a record has 2 

of the same field.  And I don't know if the two name fields are identical
(and are actually two

fields with the same name), or two different names (e.g. maiden name and
married name),

or if one is the actual patron name, and the other has completely
different data but was given 

the wrong field name. For instance, someone might have used the wrong tag
("n" which is our tag 

for the Name field) when they were actually entering an internal note
field (we use "x" for the 

Internal note field).

Sincerely,

Sue Whitehead,  Systems Librarian/Archivist

Biola University
13800 Biola Ave., La Mirada, CA  90639-0001

sue dot whitehead at biola dot edu
562-903-6000, ext. 5611
fax:  562-903-4840

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