<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Maxwell,<br>
<br>
Sorry you're having trouble. I don't see anything wrong with your data
(except that the 952 fields are filed strangely; I don't know if that
matters). I suggest you ask the very helpful members of the MARCEDIT-L
list as well (if you haven't already): <br>
<br>
<a class="moz-txt-link-freetext" href="http://listserv.gmu.edu/cgi-bin/wa?SUBED1=MARCEDIT-L&A=1">http://listserv.gmu.edu/cgi-bin/wa?SUBED1=MARCEDIT-L&A=1</a><br>
<br>
Good luck!<br>
<br>
<div class="moz-signature"><span
style="font-size: 12px; font-family: Arial;">
<p>Cheers,</p>
<p>Christopher Curry<br>
Assistant Technical Librarian / Assistant IT Officer</p>
<p>American Philosophical Society<br>
105 South Fifth Street<br>
Philadelphia, PA 19106-3386<br>
Tel. (215) 599-4299</p>
<p><a href="mailto:ccurry@amphilsoc.org">ccurry@amphilsoc.org</a></p>
Main Library number: (215)440-3400<br>
APS website: <a href="http://www.amphilsoc.org">http://www.amphilsoc.org</a>
<p><br>
</p>
</span>
</div>
<br>
On 10/29/2010 06:40 AM, SlyzertVoltrond wrote:
<blockquote
cite="mid:AANLkTikdnW1-qNxVfDWVOiWRPKc9NWbuP2d19YMQpmg2@mail.gmail.com"
type="cite">
<pre wrap="">Christopher,
Sorry for posting mutiple copies of the same mail, I was trying to
make contents of the mail appear in the Koha mailing list, but to no
avail. I don't know why it came up emtpy
1. Yes, I did. I also tried executing the strings without $b
string(and excluding $6 too, I guess), temporarily moving other
subfields in 952 to another field, only left $h and $i in there. And
just incase, I also create a new $o subfield. But the result is still
the same, it doesn't replace anything.
Here are sample records(with other 952 subfields moved to another field):
=LDR 00569nam 22001691a 4500
=020 \\$a9839340042$c0.00
=952 \\$h344.59501$iMAI
=082 \\$bMAI
=100 \\$aMAIMUNAH Aminuddin
=245 \\$aAn A - Z of Malaysian employment law$h[Text]
=260 \\$aKuala Lumpur$bMcGraw-Hill Book$c1999
=300 \\$a215p.
=600 \\$aIndustrial Relations - Laws and Legislations - Malaysia
=600 \\$aMalaysian labour law and legislation
=600 \\$aTrade-unions - law and legislation - Malaysia
=850 \\$aMaybank Library
=852 \\$aMalayan Banking Berhad$t0$g49.90$pG11184MACL$cLibrary (General)
=LDR 00441nam 22001571a 4500
=020 \\$c0.00
=952 \\$h657.33$iBER
=082 \\$bBER
=100 \\$aBERNSTEIN, Leopold A.
=245 \\$aThe analysis of financial statements$h[Text]
=260 \\$aIllinois$bRichard D. Irwin$c1978
=300 \\$a311p.
=600 \\$aFinancial Statements
=600 \\$aManagerial Accounting
=850 \\$aMaybank Library
=852 \\$aMalayan Banking Berhad$t0$g54.14$pG02149MACL$cLibrary (General)
Does anyone have any idea what I did wrong?
regards,
Maxwell
On Fri, Oct 29, 2010 at 12:43 AM, Christopher Curry
<a class="moz-txt-link-rfc2396E" href="mailto:ccurry@amphilsoc.org"><ccurry@amphilsoc.org></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Maxwell,
I'm no RegExpert, but perhaps this will help:
1. Did you first move your 852$h data and 852$i to 952$h & 952$i,
respectively? This RegEx string is looking for data in 952$h & 952$i. BTW,
you'll probably want to exclude the "(\$.*\$b[A-Za-z0-9.]*)" string unless
you have $b data to parse. When I used this find & replace string I'm
pretty sure I moved the $h & $i to 952 first, combined them into $o using
the RegEx, then moved other subfields from 852 that I wanted to map to 952
subfields. If you have other subfields in 952 when you run this, it can gum
up the works (I think).
2. This find & replace operation is looking for any data in $h & $i and
concatenating it in a new $o.
$1 $2 $3 $4 $5 $6
(=952 ..) (\$h) ([A-Za-z0-9.]*) (\$i) ([A-Za-z0-9.]*)
(\$.*\$b[A-Za-z0-9.]*)
The find string breaks down the 952 field into its constituent parts.
$1$o$3 $5$6
The replace string reassembles the parts in the order you specify, so the
result should be:
=952 ..$o[The result of "([A-Za-z0-9.]*)" after (\$h), $3] [The result of
"([A-Za-z0-9.]*)" after (\$i), $5][The result of "(\$.*\$b[A-Za-z0-9.]*)",
$6]
Hope this helps.
Cheers,
Christopher Curry
Assistant Technical Librarian / Assistant IT Officer
American Philosophical Society
105 South Fifth Street
Philadelphia, PA 19106-3386
Tel. (215) 599-4299
<a class="moz-txt-link-abbreviated" href="mailto:ccurry@amphilsoc.org">ccurry@amphilsoc.org</a>
Main Library number: (215)440-3400
APS website: <a class="moz-txt-link-freetext" href="http://www.amphilsoc.org">http://www.amphilsoc.org</a>
On 10/28/2010 12:19 PM, SlyzertVoltrond wrote:
>From the link you gave me:
"Next enter the following string into the 'Find what' box:
(=952 ..)(\$h)([A-Za-z0-9.]*)(\$i)([A-Za-z0-9.]*)(\$.*\$b[A-Za-z0-9.]*)
This will take the data from the $h field (and the data could be
capital letters, lower case letters, numbers and decimals) and the
data from the $i string (and the data could be capital letters, lower
case letters, numbers and decimals) and $b is the last subfield in the
952 field.
TIP: This regular expression may need to be changed depending on the
type of data you have in your system. Libraries that use the LC
classification system in particular may need to tweak the “replace”
command to find and move cutters.
And enter the following string into the 'Replace with' box:
$1$o$3 $5$6
This string is saying stay in the same field number as in parenthesis
#1, move the data from parenthesis #3 of the 'Find what' string next
to $o, add a space, take the data from parenthesis #5 and move it to
$o as well, then check to the end of the field and leave all the other
subfield data alone."
-------------------------------------------------------------------------------------------------------------------------------------------------
I tried doing the above on my records, but I think it only finds the
data and doesn't replace anything, because it said "0 modifications
were made." and took a few seconds to finish. Any ideas on how to move
the subfields?
regards,
Maxwell
2010/10/28 Christopher Curry <a class="moz-txt-link-rfc2396E" href="mailto:ccurry@amphilsoc.org"><ccurry@amphilsoc.org></a>:
Maxwell,
Have a look at the "Swapping Fields" section of this page in the old
koha.org manual. It explains how to accomplish this by first moving the 852
$h & $i to 952 $h & $i, then using a RegEx to combine the two fields into
one $o subfield:
<a class="moz-txt-link-freetext" href="http://koha.org/documentation/tutorial/using-marcedit/tutorial-all-pages">http://koha.org/documentation/tutorial/using-marcedit/tutorial-all-pages</a>
I couldn't find this information in the official docs:
<a class="moz-txt-link-freetext" href="http://koha-community.org/documentation/3-2-manual/?ch=a12459">http://koha-community.org/documentation/3-2-manual/?ch=a12459</a>
Cheers,
Christopher Curry
Assistant Technical Librarian / Assistant IT Officer
American Philosophical Society
105 South Fifth Street
Philadelphia, PA 19106-3386
Tel. (215) 599-4299
<a class="moz-txt-link-abbreviated" href="mailto:ccurry@amphilsoc.org">ccurry@amphilsoc.org</a>
Main Library number: (215)440-3400
APS website: <a class="moz-txt-link-freetext" href="http://www.amphilsoc.org">http://www.amphilsoc.org</a>
On 10/28/2010 10:13 AM, SlyzertVoltrond wrote:
How do I use MarcEdit's Find/Replace function to move 852's $h and $i
subfield data into one 952's $o subfield? If I try to swap $h of 852
to $o of 952 and then do that again for $i of 852 field, I end up
creating two $o entries in the 952 field, which I don't think is
allowed for call number subfield. Also, I don't have the slightest
idea how to use regular expressions to achieve the said task, so I
would appreciate it if someone could write it for me, or at least
guide me how to write one.
regards,
Maxwell
_______________________________________________
Koha mailing list <a class="moz-txt-link-freetext" href="http://koha-community.org">http://koha-community.org</a>
<a class="moz-txt-link-abbreviated" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a>
<a class="moz-txt-link-freetext" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
_______________________________________________
Koha mailing list <a class="moz-txt-link-freetext" href="http://koha-community.org">http://koha-community.org</a>
<a class="moz-txt-link-abbreviated" href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a>
<a class="moz-txt-link-freetext" href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
</pre>
</blockquote>
</blockquote>
</body>
</html>