<div><br></div>Just a thought, but you could run a report of all the records you want to change and use a desktop macro (like <a href="http://www.macroexpress.com/">http://www.macroexpress.com/</a>) to update each record in your list.<div>
<br></div><div>Thanks,</div><div>-- Ben<br><br><div class="gmail_quote">2009/10/27 Amy Schuler <span dir="ltr"><<a href="mailto:schulera@caryinstitute.org">schulera@caryinstitute.org</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">Hello, </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">Does
anyone have any ideas regarding my problem with 852/952 $m. The problem
is that, in editing all of my holdings data to migrate nicely into Koha, I
cannot figure out how to migrate my old 852 $m data (call number suffix, a
standard MARC subfield, I have publication years and volume #s stored in this
field). When I use MarcEdit to swap fields & edit data, I can write a
regular expression that will find all 852 $h, i, and m and move them to 952
$o. However, this only finds & replaces those 852s that have all 3 of
those subfields. Most of my records do not have all 3, they only have $h
and i. So, when I run a second find & replace to pick up the 852s
that only have those two subfields, then a second 952 $o is created.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">In
short, it seems that my choices in regard to $m data are: (1) move $m to some
completely different subfield ($z public note, $t copy number? Little
misleading), or (2) have 2 instances of $o in some of my 952 fields, although I
am not sure how this will render, or even whether Koha will accept this (is $o
repeatable??) </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">I hope I
have been clear. Please let me know if you have ideas. I am running
Koha v. 3.0001005 and I attach a sample record (with most edits made) below.
Note that this record contains two 952s because it is a 2 volume set, as well
as the $m’s.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=LDR
01105cam 2200301 i 4500</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=001
\\\74075531\//r952</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=003
DLC</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=005
19950918112125.9</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=008
750501s1975\\\\nyua\\\\\b\\\\00010\eng\\</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=010
\\$a 74075531 //r952</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=020
\\$a091384800X</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=040
\\$aDLC$cDLC$dDLC</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=043
\\$an-us---</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=050
\\$aQH76$b.E36</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=082
00$a333.7/2</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=100
10$aEgler, Frank Edwin,$d1911-</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=245
14$aThe plight of the rightofway domain :$bvictim of vandalism /$cby Frank E.
Egler, consultant, and Stan R. Foote.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=260
0\$aMt. Kisco, N.Y. :$bFutura Media Services,$c[1975]</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=300
\\$a2 v. :$bill. ;$c23 cm.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=500
\\$aVol. 2 has also special title: Personalized documentation.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=504
\\$aIncludes bibliographical references.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=650
\0$aLandscape protection$zUnited States.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=650
\0$aRight of way$zUnited States.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=650
\0$aBrush$xcontrol$xEnvironmental aspects$zUnited States.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=650
\0$aPlant ecology$zUnited States.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=700
10$aFoote, Stan R.,$ejoint author.</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=952
\\$p10020$oHC 110 .E5 E35$mv.1$d20030108</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif"">=952
\\$p10021$oHC 110 .E5 E35$mv.2$d20030108</span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Lucida Bright","serif"">Amy
C. Schuler</span><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Lucida Bright","serif"">Manager
of Information Services</span><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Lucida Bright","serif"">Cary
Institute of Ecosystem Studies</span><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Lucida Bright","serif"">PO
Box AB </span><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Lucida Bright","serif"">Millbrook,
NY 12545</span><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Lucida Bright","serif"">(845)
677-7600 x164</span><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""><a href="mailto:schulera@ecostudies.org" target="_blank"><span style="color:blue">schulera@caryinstitute.org</span></a></span><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""> </span><span style="font-size:10.0pt;font-family:"Lucida Bright","serif""></span></p>
<p class="MsoNormal"> </p>
</div>
</div>
<br>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br></div>