<!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>
I'm no RegExpert, but perhaps this will help:<br>
<br>
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).<br>
<br>
2. This find & replace operation is looking for any data in $h
& $i and concatenating it in a new $o.<br>
<br>
$1 $2 $3 $4 $5
$6<br>
(=952 ..) (\$h) ([A-Za-z0-9.]*) (\$i) ([A-Za-z0-9.]*)
(\$.*\$b[A-Za-z0-9.]*)<br>
<br>
The find string breaks down the 952 field into its constituent parts.<br>
<br>
$1$o$3 $5$6<br>
<br>
The replace string reassembles the parts in the order you specify, so
the result should be:<br>
<br>
=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]<br>
<br>
Hope this helps.<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/28/2010 12:19 PM, SlyzertVoltrond wrote:
<blockquote
cite="mid:AANLkTikqdqMMg6BT0YyNURrVfRjVZGF5Jmknt7s19rJd@mail.gmail.com"
type="cite">
<pre wrap="">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>:
</pre>
<blockquote type="cite">
<pre wrap="">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>