<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">&lt;<a href="mailto:schulera@caryinstitute.org">schulera@caryinstitute.org</a>&gt;</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:&quot;Times New Roman&quot;,&quot;serif&quot;">Hello, </span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;"> </span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">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 &amp; 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 &amp; 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 &amp; 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:&quot;Times New Roman&quot;,&quot;serif&quot;"> </span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">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:&quot;Times New Roman&quot;,&quot;serif&quot;"> </span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">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:&quot;Times New Roman&quot;,&quot;serif&quot;"> </span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;"> </span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=LDR 
01105cam  2200301 i 4500</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=001 
\\\74075531\//r952</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=003 
DLC</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=005 
19950918112125.9</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=008 
750501s1975\\\\nyua\\\\\b\\\\00010\eng\\</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=010 
\\$a   74075531 //r952</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=020 
\\$a091384800X</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=040 
\\$aDLC$cDLC$dDLC</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=043 
\\$an-us---</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=050 
\\$aQH76$b.E36</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=082 
00$a333.7/2</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=100 
10$aEgler, Frank Edwin,$d1911-</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=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:&quot;Times New Roman&quot;,&quot;serif&quot;">=260 
0\$aMt. Kisco, N.Y. :$bFutura Media Services,$c[1975]</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=300 
\\$a2 v. :$bill. ;$c23 cm.</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=500 
\\$aVol. 2 has also special title: Personalized documentation.</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=504 
\\$aIncludes bibliographical references.</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=650 
\0$aLandscape protection$zUnited States.</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=650 
\0$aRight of way$zUnited States.</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=650 
\0$aBrush$xcontrol$xEnvironmental aspects$zUnited States.</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=650 
\0$aPlant ecology$zUnited States.</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=700 
10$aFoote, Stan R.,$ejoint author.</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=952 
\\$p10020$oHC 110 .E5 E35$mv.1$d20030108</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;">=952 
\\$p10021$oHC 110 .E5 E35$mv.2$d20030108</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;"> </span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;"> </span></p>

<p class="MsoNormal"><span style="font-family:&quot;Times New Roman&quot;,&quot;serif&quot;"> </span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;">Amy
C. Schuler</span><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"></span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;">Manager
of Information Services</span><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"></span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;">Cary
Institute of Ecosystem Studies</span><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"></span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;">PO
Box AB </span><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"></span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;">Millbrook,
NY  12545</span><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"></span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;">(845)
677-7600 x164</span><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"></span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"><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:&quot;Lucida Bright&quot;,&quot;serif&quot;"></span></p>


<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"> </span><span style="font-size:10.0pt;font-family:&quot;Lucida Bright&quot;,&quot;serif&quot;"></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>