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]
|
