MARCEDIT-L Archives

September 2021

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Paul Schaffner <[log in to unmask]>
Reply To:
Date:
Thu, 2 Sep 2021 12:51:32 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (63 lines)
I hesitate to mention this, since it takes one out of ME proper, but 
most questions of the sort "which records are in X but not in Y" 
can be readily addressed by means of those ancient utilities
SORT, COMM, GREP, and UNIQ (native to Unix but ported to Windows -- and
my standbys). If you have unique identifiers in your records (say
in the =001 field), and you are able to extract them from the mnemonic
MarcEdit format files (say with a text editor or grep), and sort them,
then 'comm,' a beautiful little gem of a utility, will quickly tell you
which IDs are in the source files but not in the 'joined' file. That's
exactly what it is for, and it does its work almost instantaneously.
And of course once you discover which IDs are missing, you'll know which
records are missing. I'm not sure I could live without comm.

pfs

ps I assume that a number dropped out before the words "were lost"; "ten"?


On Thu, 2 Sep 2021, at 12:28, Terry Reese wrote:
> It is honestly difficult to answer questions like this without seeing 
> the files.  Marcedit itself, when processing individual files fixes 
> structure issues on the fly.  Join does not.  My guess, there are 
> potentially structural issues in the file
> 
> On Thu, Sep 2, 2021, 12:21 PM Leslie Engelson <[log in to unmask]> wrote:
> > Hello:
> > 
> > I had 8 files that had a total of 6007 records between then. None of the records were duplicates. When I joined them, 8 records were duplicated in the joined file and were lost somehow resulting in 6005 in the joined file.
> > 
> > I can locate the duplicated records easily but can't figure out how to find which records were not included in the joined file. Can anyone help me know how to figure this out?
> > 
> > Also, why is this happening? I want to send the joined file for authority processing but I don't want to send duplicate records and I want to send all of the unique records so I'd like to resolve this problem
> > 
> > Thanks for your help
> > 
> > Leslie
> > *
> *
> > * *
> > Leslie Engelson
> > 
> > Metadata Librarian / Professor
> > [log in to unmask]
> > 
> > Murray State University 
> > 270-809-4818 
> > Waterfield Library 224GMurray State University 
> > http://secure-web.cisco.com/1oQu4lslJMylf50I4qzT8Cv95EcRwstDPWEJarDhcz9Vfz9-J0xFssTcjlshxLeLnJmubOiUjAD3bGBLEUDiY7zxb9SlCYHI_sO9xbk1eRt0OAcPPWVoKKzGi3xcCr82BaiIKr_diGZ6nsGUQrYv-Abn_KX2tcR-5mi93osnBQx5gkHaaUZdeXLT7L6h35XQDOVdSpbag-k4mhD7EBMb-TLOVk2hoIuvUWPcNGaTGZ6GANhMpkLsr6t8ylDBozZr3zgRgaK8I3kwQe2IyDiC6vrTSqhoXpForKyvxr2o86ztt-zRzgVhv9yUGomcuoa7OS0Q_D-2W80GcR-I5-5GS2sge7En6iRunKreFopWWabVgOykG9y75OnznoXqW4vLXzmXVKbRWU6xRpm-80BznTwUUpqQg_4FgQqZOuCuKcgB8ZoAhBYJ5_0_6J2-fKbpFbXgi-PbohixpMh9WtV6XPg/http%3A%2F%2Flib.murraystate.edu <http://secure-web.cisco.com/1eUed8GTa3e7LIwy78Zog-EGn-Cx6zDY8OirfhY1UOVC1hoY_yHDch1TLhZuQ-E3jdSjkKPTNYYwyvYIVsi8J4WYl78YweOFCtTAhfSWKUlTKk6D-ed3RBsDocnbUAhKZ5E6jlbTgf9eQ69_jVHsmkL0EdkxoMnPTf8vTNZr1Y9SVdXnjEQFtMFAyRnNfbBm1zqafT5MznmW-G3Fh-PF55-yXo189RyRH_Gf8PTuk37-PUBInRoLZH2fqfQirAoe4YCEQ_mYxyD5bfhTHfmybt2dOQagLXREPWXmtLBdWfvD1in2JqZ3wsdglP7j0J3bXn1ZsjCwqtMoH4CNXzwoxgPJM9WdZVFqEtQBNILwAkISZOjWrR-8qm0L2uWjz_8anlmaSJTH43FnhsI-wiDJ0gPXlYGmzeONtzZjs06_Ooz1b1sDdkMpAg9LnyRc5KbXtTC72wP-_jN8V1-v3RR4qvw/http%3A%2F%2Flib.murraystate.edu%2F>
> > 
> > 
> > 
> ________________________________________________________________________ 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] 


-- 
Paul Schaffner  UM Library : Digital Content & Collections
[log in to unmask] | http://secure-web.cisco.com/1vhB_I2IukWcHrTXCU7U7-0waTlisqTymBuUl3eisMMCj4_WqqH-PbiaaTnOSYZ6r3NRk1qFShFf1mpm8NnYBBlMJj1luQIWpbJMivsG6ry1zp1-FhleuejysY3WX6-EWRr1K6G93t7Gd-rAzcT47Gw2ycDInWO2DynOVINlLUjZjiSRAQIokreN2pN-yzBfiwRn1QaKFCmWHoWMj9iCeRsh8uxB2lGOAaCS2g-fFazjrjIsa_iwsI4YJRLy6EGZfXYoBm7swxnzNv00zBqLx-ZiZS7o-bpCDOBxpDjx68F8PZgkpbpIb98ERxsmC0rg0BVHrPHzGIwG16q8F39nkeXUYEa_fgrgwFm5XsbAKSt98n3kmLJcHVEGgafaDr5DLuxSg5vEmJUwOoTFkDdYXjm0IR1MiJHNDux1rqrLl6mbHqpJbmcu1UwAp-OUlzI8MBQ0c4uXUxDOpAFO6zRY3-g/http%3A%2F%2Fwww.umich.edu%2F%7Epfs%2F

________________________________________________________________________

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]

ATOM RSS1 RSS2