I was at another great Code4Lib event (Midwest) and heard about a perl script that was created by Roy Zimmer at Western Michigan that can pull every n-th MARC record from a large file. I saw this as immediately useful for sampling vendor records.
http://homepages.wmich.edu/~zimmer/marc_index.html
marcnth.pl marcnth.pl -infile=file -startrec=N [-howmany=N] [-raw]
Retrieves the Nth record, or several records starting at record N, from a MARC file or one that has been converted to human-readable format by marcread.pl (found elsewhere on this page). The file type is sensed by marcnth. Use the -raw parameter with a MARC file to retrieve the actual MARC record(s).
Is this the sort of feature that could be incorporated into a future release??
David B. Malone, MLIS, CA
Associate Professor
Buswell Memorial Library
Wheaton College
501 College Ave.
Wheaton IL 60187-5593
630.752.5707 | 630.752.5987 FAX
[log in to unmask] | http://library.wheaton.edu
________________________________________
From: MarcEdit support in technical and instructional matters <[log in to unmask]> on behalf of MARCEDIT-L automatic digest system <[log in to unmask]>
Sent: Thursday, July 24, 2014 11:00 PM
To: [log in to unmask]
Subject: MARCEDIT-L Digest - 23 Jul 2014 to 24 Jul 2014 (#2014-138)
There are 3 messages totalling 757 lines in this issue.
Topics of the day:
1. Merge data matching on 035 field (2)
2. records duplicating in a large file
________________________________________________________________________
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]
----------------------------------------------------------------------
Date: Wed, 23 Jul 2014 23:49:59 -0400
From: Yael Mandelstam <[log in to unmask]>
Subject: Re: Merge data matching on 035 field
--001a11c1be70fd9d6d04fee85a41
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Hi Terry,
This would be a good option. In the meantime, the matching was not done
when I changed all the $z to $a. I am assuming that it's because $a is not
repeatable, so the system only matches on the first 035$a and ignores the
subsequent $a in the string. If that's the case, is there a way to swap the
data in each 035$z into a separate 035$a?
ym
On Wed, Jul 23, 2014 at 9:55 PM, Terry Reese <[log in to unmask]> wrote:
> In creating the tool, the $z was specifically left off when doing control
> number matching. It would be easy enough to add to the program =E2=80=93=
I could
> add it as an option in the MARC21 setup =E2=80=93 but I=E2=80=99m thinkin=
g you=E2=80=99d probably
> want it turned off by default.
>
>
>
> --tr
>
>
>
> *From:* MarcEdit support in technical and instructional matters [mailto:
> [log in to unmask]] *On Behalf Of *Yael Mandelstam
> *Sent:* Wednesday, July 23, 2014 6:07 PM
> *To:* [log in to unmask]
> *Subject:* [MARCEDIT-L] Merge data matching on 035 field
>
>
>
> I am merging data from OCLC records into some vendor records that have
> OCLC numbers in field 035. The problem I am facing is that many of the OC=
LC
> records have gone through multiple mergers, resulting in multiple 035$z.
> Here is an example:
>
>
>
> 035 field in vendor record: $a(OCoLC)124067068
>
> 035 field in OCLC record:
> $a(OCoLC)77598965$z(OCoLC)124067068$z(OCoLC)148809821$z(OCoLC)776124277$z=
(OCoLC)874311679
>
>
>
> (In this case the first $z matches our vendor record, but in other cases
> the matching number can be somewhere further in the 035 string).
>
>
>
> I tried changing all 035 $z to $a, but the merge didn't work. Does anyone
> know if there is a way to match ANY of the numbers in the 035 string?
>
>
>
>
>
> Thanks,
>
> Yael
>
>
>
> ****************************
> Yael Mandelstam
> Head of Cataloging
> Fordham University School of Law
> The Maloney Library
>
> 150 West 62nd Street
>
> New York, NY 10023
>
> Phone: 212.636.7971
> Fax: 212.930.8818
> Email: [log in to unmask]
>
> ________________________________________________________________________
>
> This message comes to you via MARCEDIT-L, a Listserv(R) list for technica=
l
> and instructional support in MarcEdit. If you wish to communicate directl=
y
> 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 technica=
l
> and instructional support in MarcEdit. If you wish to communicate directl=
y
> 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]
--001a11c1be70fd9d6d04fee85a41
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr">Hi Terry,<div><br></div><div>This would be a good option. =
In the meantime, the matching was not done when I changed all the $z to $a.=
I am assuming that it's because $a is not repeatable, so the system on=
ly matches on the first 035$a and ignores the subsequent $a in the string. =
If that's the case, is there a way to swap the data in each 035$z into =
a separate 035$a?=C2=A0</div>
<div><br></div><div>ym</div><div class=3D"gmail_extra"><div><div dir=3D"ltr=
"><br></div></div><br><div class=3D"gmail_quote">On Wed, Jul 23, 2014 at 9:=
55 PM, Terry Reese <span dir=3D"ltr"><<a href=3D"mailto:[log in to unmask]
" target=3D"_blank">[log in to unmask]</a>></span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div lang=3D"EN-US" link=3D"blue" vlink=3D"p=
urple"><div><p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-fam=
ily:"Calibri","sans-serif";color:#1f497d">In creating t=
he tool, the $z was specifically left off when doing control number matchin=
g.=C2=A0 It would be easy enough to add to the program =E2=80=93 I could ad=
d it as an option in the MARC21 setup =E2=80=93 but I=E2=80=99m thinking yo=
u=E2=80=99d probably want it turned off by default.<u></u><u></u></span></p=
>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1f497d"><u></u>=C2=A0<u></u></spa=
n></p><p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:&q=
uot;Calibri","sans-serif";color:#1f497d">--tr<u></u><u></u><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca=
libri","sans-serif";color:#1f497d"><u></u>=C2=A0<u></u></spa=
n></p><p class=3D"MsoNormal"><b><span style=3D"font-size:11.0pt;font-family=
:"Calibri","sans-serif"">From:</span></b><span style=3D=
"font-size:11.0pt;font-family:"Calibri","sans-serif""> =
MarcEdit support in technical and instructional matters [mailto:<a href=3D"=
mailto:[log in to unmask]" target=3D"_blank">[log in to unmask]
du</a>] <b>On Behalf Of </b>Yael Mandelstam<br>
<b>Sent:</b> Wednesday, July 23, 2014 6:07 PM<br><b>To:</b> <a href=3D"mail=
to:[log in to unmask]" target=3D"_blank">[log in to unmask]</=
a><br><b>Subject:</b> [MARCEDIT-L] Merge data matching on 035 field<u></u><=
u></u></span></p>
<div><div class=3D"h5"><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p><div>=
<div><p class=3D"MsoNormal">I am merging data from OCLC records into some v=
endor records that have OCLC numbers in field 035. The problem I am facing =
is that many of the OCLC records have gone through multiple mergers, result=
ing in multiple 035$z. Here is an example:<u></u><u></u></p>
</div><div><div><p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p></div><block=
quote style=3D"margin-left:30.0pt;margin-right:0in"><div><p class=3D"MsoNor=
mal">035 field in vendor record: $a(OCoLC)124067068<u></u><u></u></p></div>=
<div><div>
<p class=3D"MsoNormal">035 field in OCLC record: $a(OCoLC)77598965$z(OCoLC)=
124067068$z(OCoLC)148809821$z(OCoLC)776124277$z(OCoLC)874311679=C2=A0<u></u=
><u></u></p></div></div></blockquote><div><div><p class=3D"MsoNormal"><u></=
u>=C2=A0<u></u></p>
</div><div><p class=3D"MsoNormal">(In this case the first $z matches our ve=
ndor record, but in other cases the matching number can be somewhere furthe=
r in the 035 string).<u></u><u></u></p></div><div><p class=3D"MsoNormal"><u=
></u>=C2=A0<u></u></p>
</div><div><p class=3D"MsoNormal">I tried changing all 035 $z to $a, but th=
e merge didn't work. Does anyone know if there is a way to match ANY of=
the numbers in the 035 string?<u></u><u></u></p></div><div><p class=3D"Mso=
Normal">
<u></u>=C2=A0<u></u></p></div><div><p class=3D"MsoNormal"><u></u>=C2=A0<u><=
/u></p></div><div><p class=3D"MsoNormal">Thanks,<u></u><u></u></p></div><di=
v><p class=3D"MsoNormal">Yael<u></u><u></u></p></div><div><div><div><div><d=
iv><p class=3D"MsoNormal">
<u></u>=C2=A0<u></u></p></div><div><p class=3D"MsoNormal"><span style=3D"fo=
nt-family:"Arial","sans-serif"">***********************=
*****<br>Yael Mandelstam<br>Head of Cataloging<br>Fordham University School=
of Law<br>
The Maloney Library</span><u></u><u></u></p></div><div><p class=3D"MsoNorma=
l"><span style=3D"font-family:"Arial","sans-serif"">150=
West 62nd Street</span><u></u><u></u></p></div><div><p class=3D"MsoNormal"=
>
<span style=3D"font-family:"Arial","sans-serif"">New Yo=
rk, NY 10023<br>
<br>Phone: 212.636.7971<br>Fax: 212.930.8818<br>Email: <a href=3D"mailto:ym=
[log in to unmask]" target=3D"_blank">[log in to unmask]</a=
></span><u></u><u></u></p></div></div></div></div></div></div></div></div>
</div>
</div><p class=3D"MsoNormal">______________________________________________=
__________________________ <u></u><u></u></p><p>This message comes to you v=
ia MARCEDIT-L, a Listserv(R) list for technical and instructional support i=
n MarcEdit. If you wish to communicate directly with the list owners, write=
to <a href=3D"mailto:[log in to unmask]" target=3D"_blank=
">[log in to unmask]</a>. To unsubscribe, send a message &=
quot;SIGNOFF MARCEDIT-L" to <a href=3D"mailto:[log in to unmask]
u" target=3D"_blank">[log in to unmask]</a>. <u></u><u></u></p>
</div></div>
________________________________________________________________________
<p>
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 <a href=3D"mailto:MARCEDIT-L-request@listse=
rv.gmu.edu" target=3D"_blank">[log in to unmask]</a>. To u=
nsubscribe, send a message "SIGNOFF MARCEDIT-L" to <a href=3D"mai=
lto:[log in to unmask]" target=3D"_blank">[log in to unmask]<=
/a>.</p>
</blockquote></div><br></div></div>
________________________________________________________________________
<p>
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]
--001a11c1be70fd9d6d04fee85a41--
------------------------------
Date: Thu, 24 Jul 2014 08:12:25 -0400
From: Terry Reese <[log in to unmask]>
Subject: Re: Merge data matching on 035 field
This is a multipart message in MIME format.
------=_NextPart_000_007F_01CFA717.01758880
Content-Type: text/plain;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
The 035 is a value that can be handled in aggregate =E2=80=93 but =
it=E2=80=99s not treated the same way as the 001, so it=E2=80=99s match =
value isn=E2=80=99t treated like the record control number. Depending =
on the other data in the record, it could skew the matches. Feel free =
to send some samples and I=E2=80=99ll see how they work with the updated =
process in MarcEdit 6.
=20
--tr
=20
From: MarcEdit support in technical and instructional matters =
[mailto:[log in to unmask]] On Behalf Of Yael Mandelstam
Sent: Wednesday, July 23, 2014 11:50 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] Merge data matching on 035 field
=20
Hi Terry,
=20
This would be a good option. In the meantime, the matching was not done =
when I changed all the $z to $a. I am assuming that it's because $a is =
not repeatable, so the system only matches on the first 035$a and =
ignores the subsequent $a in the string. If that's the case, is there a =
way to swap the data in each 035$z into a separate 035$a?=20
=20
ym
=20
=20
On Wed, Jul 23, 2014 at 9:55 PM, Terry Reese <[log in to unmask] =
<mailto:[log in to unmask]> > wrote:
In creating the tool, the $z was specifically left off when doing =
control number matching. It would be easy enough to add to the program =
=E2=80=93 I could add it as an option in the MARC21 setup =E2=80=93 but =
I=E2=80=99m thinking you=E2=80=99d probably want it turned off by =
default.
=20
--tr
=20
From: MarcEdit support in technical and instructional matters =
[mailto:[log in to unmask] <mailto:[log in to unmask]> ] =
On Behalf Of Yael Mandelstam
Sent: Wednesday, July 23, 2014 6:07 PM
To: [log in to unmask] <mailto:[log in to unmask]>=20
Subject: [MARCEDIT-L] Merge data matching on 035 field
=20
I am merging data from OCLC records into some vendor records that have =
OCLC numbers in field 035. The problem I am facing is that many of the =
OCLC records have gone through multiple mergers, resulting in multiple =
035$z. Here is an example:
=20
035 field in vendor record: $a(OCoLC)124067068
035 field in OCLC record: =
$a(OCoLC)77598965$z(OCoLC)124067068$z(OCoLC)148809821$z(OCoLC)776124277$z=
(OCoLC)874311679=20
=20
(In this case the first $z matches our vendor record, but in other cases =
the matching number can be somewhere further in the 035 string).
=20
I tried changing all 035 $z to $a, but the merge didn't work. Does =
anyone know if there is a way to match ANY of the numbers in the 035 =
string?
=20
=20
Thanks,
Yael
=20
****************************
Yael Mandelstam
Head of Cataloging
Fordham University School of Law
The Maloney Library
150 West 62nd Street
New York, NY 10023
Phone: 212.636.7971
Fax: 212.930.8818
Email: [log in to unmask] <mailto:[log in to unmask]>=20
________________________________________________________________________ =
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] =
<mailto:[log in to unmask]> . To unsubscribe, send a =
message "SIGNOFF MARCEDIT-L" to [log in to unmask] =
<mailto:[log in to unmask]> .=20
________________________________________________________________________ =
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] =
<mailto:[log in to unmask]> . To unsubscribe, send a =
message "SIGNOFF MARCEDIT-L" to [log in to unmask] =
<mailto:[log in to unmask]> .
=20
________________________________________________________________________ =
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] =
<mailto:[log in to unmask]> . To unsubscribe, send a =
message "SIGNOFF MARCEDIT-L" to [log in to unmask] =
<mailto:[log in to unmask]> .=20
________________________________________________________________________
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]
------=_NextPart_000_007F_01CFA717.01758880
Content-Type: text/html;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"><head><meta =
http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"><meta =
name=3DGenerator content=3D"Microsoft Word 15 (filtered =
medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue =
vlink=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>The =C2=A0035 is a value that can be handled in aggregate =E2=80=93 =
but it=E2=80=99s not treated the same way as the 001, so it=E2=80=99s =
match value isn=E2=80=99t treated like the record control number.=C2=A0 =
Depending on the other data in the record, it could skew the =
matches.=C2=A0 Feel free to send some samples and I=E2=80=99ll see how =
they work with the updated process in MarcEdit =
6.<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p> </o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>--tr<o:p></o:p></span></p><p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'><o:p> </o:p></span></p><p class=3DMsoNormal><b><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif"'>From:</span=
></b><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif"'> MarcEdit =
support in technical and instructional matters =
[mailto:[log in to unmask]] <b>On Behalf Of </b>Yael =
Mandelstam<br><b>Sent:</b> Wednesday, July 23, 2014 11:50 =
PM<br><b>To:</b> [log in to unmask]<br><b>Subject:</b> Re: =
[MARCEDIT-L] Merge data matching on 035 field<o:p></o:p></span></p><p =
class=3DMsoNormal><o:p> </o:p></p><div><p class=3DMsoNormal>Hi =
Terry,<o:p></o:p></p><div><p =
class=3DMsoNormal><o:p> </o:p></p></div><div><p =
class=3DMsoNormal>This would be a good option. In the meantime, the =
matching was not done when I changed all the $z to $a. I am assuming =
that it's because $a is not repeatable, so the system only matches on =
the first 035$a and ignores the subsequent $a in the string. If that's =
the case, is there a way to swap the data in each 035$z into a separate =
035$a? <o:p></o:p></p></div><div><p =
class=3DMsoNormal><o:p> </o:p></p></div><div><p =
class=3DMsoNormal>ym<o:p></o:p></p></div><div><div><div><p =
class=3DMsoNormal><o:p> </o:p></p></div></div><p =
class=3DMsoNormal><o:p> </o:p></p><div><p class=3DMsoNormal>On Wed, =
Jul 23, 2014 at 9:55 PM, Terry Reese <<a =
href=3D"mailto:[log in to unmask]" =
target=3D"_blank">[log in to unmask]</a>> =
wrote:<o:p></o:p></p><blockquote style=3D'border:none;border-left:solid =
#CCCCCC 1.0pt;padding:0in 0in 0in =
6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>In creating the tool, the $z was specifically left off when doing =
control number matching. It would be easy enough to add to the =
program =E2=80=93 I could add it as an option in the MARC21 setup =
=E2=80=93 but I=E2=80=99m thinking you=E2=80=99d probably want it turned =
off by default.</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'> </span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'>--tr</span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497=
D'> </span><o:p></o:p></p><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif"'>From:</span=
></b><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif"'> MarcEdit =
support in technical and instructional matters [mailto:<a =
href=3D"mailto:[log in to unmask]" =
target=3D"_blank">[log in to unmask]</a>] <b>On Behalf Of =
</b>Yael Mandelstam<br><b>Sent:</b> Wednesday, July 23, 2014 6:07 =
PM<br><b>To:</b> <a href=3D"mailto:[log in to unmask]" =
target=3D"_blank">[log in to unmask]</a><br><b>Subject:</b> =
[MARCEDIT-L] Merge data matching on 035 =
field</span><o:p></o:p></p><div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p><=
/o:p></p><div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I am =
merging data from OCLC records into some vendor records that have OCLC =
numbers in field 035. The problem I am facing is that many of the OCLC =
records have gone through multiple mergers, resulting in multiple 035$z. =
Here is an example:<o:p></o:p></p></div><div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p><=
/o:p></p></div><blockquote =
style=3D'margin-left:30.0pt;margin-top:5.0pt;margin-right:0in;margin-bott=
om:5.0pt'><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>035 field =
in vendor record: $a(OCoLC)124067068<o:p></o:p></p></div><div><div><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>035 field =
in OCLC record: =
$a(OCoLC)77598965$z(OCoLC)124067068$z(OCoLC)148809821$z(OCoLC)776124277$z=
(OCoLC)874311679 <o:p></o:p></p></div></div></blockquote><div><div><=
p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p><=
/o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>(In this =
case the first $z matches our vendor record, but in other cases the =
matching number can be somewhere further in the 035 =
string).<o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p><=
/o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I tried =
changing all 035 $z to $a, but the merge didn't work. Does anyone know =
if there is a way to match ANY of the numbers in the 035 =
string?<o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p><=
/o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p><=
/o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Thanks,<o:p>=
</o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Yael<o:p></o=
:p></p></div><div><div><div><div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p><=
/o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
style=3D'font-family:"Arial","sans-serif"'>****************************<b=
r>Yael Mandelstam<br>Head of Cataloging<br>Fordham University School of =
Law<br>The Maloney Library</span><o:p></o:p></p></div><div><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
style=3D'font-family:"Arial","sans-serif"'>150 West 62nd =
Street</span><o:p></o:p></p></div><div><p class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span =
style=3D'font-family:"Arial","sans-serif"'>New York, NY =
10023<br><br>Phone: 212.636.7971<br>Fax: 212.930.8818<br>Email: <a =
href=3D"mailto:[log in to unmask]" =
target=3D"_blank">[log in to unmask]</a></span><o:p></o:p></p></=
div></div></div></div></div></div></div></div></div></div><p =
class=3DMsoNormal =
style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>____________=
____________________________________________________________ =
<o:p></o:p></p><p>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 <a =
href=3D"mailto:[log in to unmask]" =
target=3D"_blank">[log in to unmask]</a>. To =
unsubscribe, send a message "SIGNOFF MARCEDIT-L" to <a =
href=3D"mailto:[log in to unmask]" =
target=3D"_blank">[log in to unmask]</a>. =
<o:p></o:p></p></div></div><p =
class=3DMsoNormal>_______________________________________________________=
_________________ <o:p></o:p></p><p>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 <a href=3D"mailto:[log in to unmask]" =
target=3D"_blank">[log in to unmask]</a>. To =
unsubscribe, send a message "SIGNOFF MARCEDIT-L" to <a =
href=3D"mailto:[log in to unmask]" =
target=3D"_blank">[log in to unmask]</a>.<o:p></o:p></p></blockquo=
te></div><p class=3DMsoNormal><o:p> </o:p></p></div></div><p =
class=3DMsoNormal>_______________________________________________________=
_________________ <o:p></o:p></p><p>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 <a =
href=3D"mailto:[log in to unmask]">MARCEDIT-L-request@li=
stserv.gmu.edu</a>. To unsubscribe, send a message "SIGNOFF =
MARCEDIT-L" to <a =
href=3D"mailto:[log in to unmask]">[log in to unmask]</a>. =
<o:p></o:p></p></div></body></html>
________________________________________________________________________
<p>
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]
------=_NextPart_000_007F_01CFA717.01758880--
------------------------------
Date: Thu, 24 Jul 2014 21:38:14 +0000
From: "Croft, Emily" <[log in to unmask]>
Subject: records duplicating in a large file
--_000_d5f12078936a41eaabe47950a64b4decredex1redlandsedu_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I'm working in a rather large file (13 pages), jumping around a lot, checki=
ng access in Serials Solutions and the WorldShare KB, and sometimes deletin=
g records out of the MARCedit file.
But I'm seeing something odd-apparently some records are copying themselves=
into the spaces where I've deleted another record. I can't see how or why=
or when, but when I try to jump back to a record-- and I can't jump to the=
record number since I've been deleting them and so the numbers don't match=
up anymore, so I do a Find All based on the 245. That's when I see duplic=
ate entries where there weren't before. Any edits I'd originally done to t=
he record are not duplicated into the second record.
Confusing enough? I probably haven't described it very helpfully, but I th=
ought I'd mention it and see what you recommend (besides splitting the file=
into more manageable chunks, which I've already decided to do in the futur=
e).
Thanks,
Emily Croft
Armacost Library
University of Redlands
[log in to unmask]<mailto:[log in to unmask]>
909-748-8080
________________________________________________________________________
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]
--_000_d5f12078936a41eaabe47950a64b4decredex1redlandsedu_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">I’m working in a rather large file (13 pages),=
jumping around a lot, checking access in Serials Solutions and the WorldSh=
are KB, and sometimes deleting records out of the MARCedit file.<o:p></o:p>=
</p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">But I’m seeing something odd—apparently =
some records are copying themselves into the spaces where I’ve delete=
d another record. I can’t see how or why or when, but when I tr=
y to jump back to a record-- and I can’t jump to the record number
since I’ve been deleting them and so the numbers don’t match u=
p anymore, so I do a Find All based on the 245. That’s when I s=
ee duplicate entries where there weren’t before. Any edits I=
217;d originally done to the record are not duplicated into the second reco=
rd.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Confusing enough? I probably haven’t des=
cribed it very helpfully, but I thought I’d mention it and see what y=
ou recommend (besides splitting the file into more manageable chunks, which=
I’ve already decided to do in the future).<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Thanks,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
<p class=3D"MsoNormal">Emily Croft<o:p></o:p></p>
<p class=3D"MsoNormal">Armacost Library<o:p></o:p></p>
<p class=3D"MsoNormal">University of Redlands<o:p></o:p></p>
<p class=3D"MsoNormal"><a href=3D"mailto:[log in to unmask]"><span st=
yle=3D"color:blue">[log in to unmask]</span></a><o:p></o:p></p>
<p class=3D"MsoNormal">909-748-8080<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>
________________________________________________________________________
<p>
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]
--_000_d5f12078936a41eaabe47950a64b4decredex1redlandsedu_--
------------------------------
End of MARCEDIT-L Digest - 23 Jul 2014 to 24 Jul 2014 (#2014-138)
*****************************************************************
________________________________________________________________________
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]
|