Hmm, no expert here, and purely working this as a thought exercise.
I would start by making copies of each file, OCLC and Springer, to play
with (just to be safe with the data! And probably park those copies in a
completely separate folder, again, just to be safe!)
Examine the record control numbers in the Springer records to see what
they look like. Do they look at all like OCLC record numbers? If not
then proceed. If they can be confused, then do a global replace on the
Springer file to replace =001 [2 spaces there] with =001 Springer.
If there is a common identifier between the records of each file --
maybe ISBNs, maybe LCCNs -- then you could merge the OCLC file into the
Springer file, doing a complete overlay. Presumably, this would replace
the Springer records with the OCLC records, including the Springer
record numbers in the 001. Then do a tab-delineated export of the 001
fields to Excel (and any others that might be useful). Sort that column
of data. Presumably the vestigial Springer 001s will sort to one end or
the other. Copy that block of data to another sheet (so you don't have
to mess with the 17k-191 records that are "clean").
Then do what you want with that spreadsheet, presumably find good OCLC
records manually. The number of scenarios after that gets large, and is
outside of what you asked, so I'll stop here.
John F. Myers, Catalog Librarian
Schaffer Library, Union College
807 Union St.
Schenectady NY 12308
518-388-6623
[log in to unmask]
-----Original Message-----
From: MarcEdit support in technical and instructional matters
[mailto:[log in to unmask]] On Behalf Of Stacy Pober
Sent: Thursday, August 12, 2010 7:12 AM
To: [log in to unmask]
Subject: How to find unique records
We get a large collection of Springer e-books. The MARC records
supplied by Springer are pretty bad. They now offer records via OCLC
which should be better quality.
Here's the problem: 119 records are missing from the OCLC set.
If I concatenate our Springer-provided MARC record files into one
file, can I then compare that to the OCLC file and pull out a set of
the books that are unique to the Springer-provided set ?
Could someone tell me the exact steps I'd need to go through to get
that file of 119 records?
Thanks!
--
Stacy Pober
Information Alchemist
Manhattan College Library
Riverdale, NY 10471
[log in to unmask]
________________________________________________________________________
This message comes to you via MARCEDIT-L, a Listserv(R) list for
technical and instructional support in MarcEdit. If you wish to
communicate directly with the list owners, write to
[log in to unmask] To unsubscribe, send a message
"SIGNOFF MARCEDIT-L" to [log in to unmask]
________________________________________________________________________
This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit. If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]
|
