MARCEDIT-L Archives

December 2013

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:
Terry Reese <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Sat, 21 Dec 2013 11:51:46 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (225 lines)
Not all at once, but if you use the swap field function, you can move
data from one field into another.

Tr

Sent from my Windows Phone From: Bothmann, Robert L
Sent: ‎12/‎21/‎2013 2:01 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] how do I merge files to include all records
WOO HOO―that worked! Joining and them running the merge/process file.

So my next question.

My records look like this:
=LDR  00102nam  2200061   45 0
=001  ocm00000058
=901  \\$aBSU
=902  \\$bMSU
=904  \\$dSCS
=906  \\$fTRM

=LDR  00102nam  2200061   45 0
=001  ocm00000059
=901  \\$aBSU
=904  \\$dSCS

=LDR  00102nam  2200061   45 0
=001  ocm00000061
=901  \\$aBSU
=904  \\$dSCS
=906  \\$fTRM



Is there a regex that will allow me to combine the 901-907s into a 900, so
that I can get this:

=LDR  00102nam  2200061   45 0
=001  ocm00000058
=900  \\$aBSU$cMSU$dSCS$fTRM
=901 \\$aBSU
=902 \\$bMSU
=904 \\$dSCS
=906 \\$fTRM


=LDR  00102nam  2200061   45 0
=001  ocm00000059
=900  \\$aBSU$dSCS
=901 \\$aBSU
=904 \\$dSCS


=LDR  00102nam  2200061   45 0
=001  ocm00000061
=900  \\$aBSU$dSCS$fTRM
=904 \\$dSCS
=906 \\$fTRM


If I can get this, then I can export as tab-demlimited and hopefully
create some graphs.

Thanks,
Bobby Bothmann


On 21/12/13, 12:10 PM, "Bothmann, Robert L" <[log in to unmask]>
wrote:

>Sort of.
>
>Say in file A we have the following:
>
>001 1
>901 A
>
>001 2
>901 A
>
>001 3
>901 A
>
>Where 001 is the OCLC number and 901 is an institution identifier.
>
>In file B we have:
>
>001 2
>902 B
>
>001 3
>902 B
>
>001 4
>902 B
>
>
>I want a file that contains All 001s and merges the records that are the
>same to get:
>
>001 1
>901 A
>
>001 2
>901 A
>902 B
>
>001 3
>901 A
>902 B
>
>001 4
>902 B
>
>
>
>The idea is to find out how much duplication of resources there are in our
>collections across the consortium.
>
>So I think your second option is what I want to do. I¹ll try that and see
>what happens.
>
>thanks!
>Bobby
>
>
>
>On 21/12/13, 11:31 AM, "Terry Reese" <[log in to unmask]> wrote:
>
>>So, let me try and understand.  You want to take the two files and merge
>>them together so you get a unique file of records?  Is that what you are
>>looking to do?  If it is, use the Dedup records tool.  From the main
>>window,
>>Tools/Dedup Records.  You'd select the two files, and match on the
>>control
>>number.  That should create a file of unique records.  If you are looking
>>to
>>get a set of unique records, but with some data from the duplicate record
>>merged into the unique record, you could use the merge record tool, but
>>you
>>need to join the two files you want to process together with MARC Join.
>>Then in the Merge tool, select the source file, and then check process
>>source file -- this will both merge and dedup the data in the source
>>file.
>>Use MARC21 for matching -- and then sit back and wait -- because this is
>>going to get a long time to process.  MarcEdit merge tool uses a lot of
>>matches and will need to track a lot of data and store large trees of
>>data
>>in memory -- so it will definitely take a while to process.
>>
>>Does that help?  I'm not sure -- because I'm not completely sure I
>>understand what you are trying to do :)
>>
>>--tr
>>
>>-----Original Message-----
>>From: MarcEdit support in technical and instructional matters
>>[mailto:[log in to unmask]] On Behalf Of Bothmann, Robert L
>>Sent: Saturday, December 21, 2013 11:02 AM
>>To: [log in to unmask]
>>Subject: [MARCEDIT-L] how do I merge files to include all records
>>
>>I'm trying to compare the unique vs. shared records across 7
>>institutions.
>>My thought for how to do this was to get the OCLC numbers from each
>>institution, add a unique identifier for the institutions, and then merge
>>the records and see which 001s with OCLC numbers end up with more than
>>one
>>institution identifier. However, I can't seem to get two files to fully
>>merge.
>>
>>So I have two files, one with 345,904 records (A) and one with 792,935
>>records (B). I want to merge them such that the unique records in both
>>files
>>end up in the merge file along with the merged records. I thought if I
>>use A
>>as the source and B as the merge then when the resulting file has at
>>least
>>792,935 records then I will have been successful. But I can't figure out
>>how
>>to do this. None of the merges will let me.
>>
>>Is there a way to do this, or a better method anyone might know of?
>>
>>Thanks,
>>Bobby Bothmann
>>
>>________________________________________________________________________
>>
>>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]
>
>________________________________________________________________________
>
>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]

________________________________________________________________________

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