<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (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;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Candara;
panose-1:2 14 5 2 3 3 3 2 2 4;}
@font-face
{font-family:"Monotype Corsiva";
panose-1:3 1 1 1 1 2 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{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";
mso-believe-normal-left:yes;}
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.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><![if mso 9]><style>p.MsoNormal
{margin-left:3.0pt;}
</style><![endif]><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='margin-left:3.0pt;margin-top:3.0pt;margin-right:3.0pt;margin-bottom:.75pt'><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>We’d like to do something similar, but the opposite. When one of our libraries drops their Overdrive subscription, we’d like to be able to remove their subfield 9 from the 856. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>So far, every time I try to tell it to remove $9 if it contains NMLSYS, all the subfields 9 are removed. Not a happy outcome for our other libraries!<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I set it up as <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Action (Rule type): Delete <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>MARC tag: 856<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Subfields: 9<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Advanced Matching Restriction: <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Subfield: 9<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Regular Expression: NMLSYS<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I know I must be missing something. I’ve looked at the Perl Regular Expressions documentation, but I’m not sure what I need to do. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Any help would be greatly appreciated. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> open-ils-general-bounces@list.georgialibraries.org [mailto:open-ils-general-bounces@list.georgialibraries.org] <b>On Behalf Of </b>Katie Wallis<br><b>Sent:</b> Friday, April 20, 2012 12:25 PM<br><b>To:</b> open-ils-general@list.georgialibraries.org<br><b>Subject:</b> Re: [OPEN-ILS-GENERAL] Question about MARC Batch edit<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>Hi Elaine,<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>Yes, it is possible to do that! When you use the rule setup in MARC Batch Edit, there's an option section called "Advanced Matching Restrictions". So you'd tell it to add subfields z and 9 to 856 but only where 856 has a subfield z that contains [fill in blank]. It would look something like this:<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>Action (Rule Type): Add<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>MARC tag: 856<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>Subfields (option): z9<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>MARC Data: 856 <a href="file:///\\$z">\\$z</a> (Patrons of participating GADD libraries please click here). $9ARL $9CHRL $9CRLS $9CPRL $9DTRL $9DCPL $9ECGR $9ECPL $9FRRLS-FA $9FRRLS $9HCLS $9HOU $9LBRL $9OCRL-DUBLN $9LEE $9MRLS $9OHOOP $9RML $9SHRL $9SGRL $9SWGRL $9STRL $9TCPLS $9THRL $9TLLS $9WORTH<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>Advanced Matching Restrictions<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>Subfield: z<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>Regular Expression: Access Georgia Download Destination<br><br>Katie<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'><br> <o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'> <o:p></o:p></span></p></div><div><div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><strong><span style='font-size:13.5pt;font-family:"Monotype Corsiva";color:#004080'>Katie Wallis</span></strong><span style='font-family:"Candara","sans-serif"'><o:p></o:p></span></p></div></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><strong><span style='font-family:"Candara","sans-serif"'>Columbia Gorge Community College Library</span></strong><span style='font-family:"Candara","sans-serif"'><o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>400 East Scenic Drive, The Dalles, OR 97058<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'><a href="mailto:kwallis@cgcc.cc.or.us">kwallis@cgcc.cc.or.us</a> | 541-506-6087<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'> <o:p></o:p></span></p></div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'>>>> <<a href="mailto:open-ils-general-request@list.georgialibraries.org">open-ils-general-request@list.georgialibraries.org</a>> 4/20/2012 9:00 AM >>><br><br> 1. Question about MARC Batch edit (Hardy, Elaine)<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin:0in;margin-bottom:.0001pt'><span style='font-family:"Candara","sans-serif"'><br>Date: Thu, 19 Apr 2012 14:04:47 -0400 (EDT)<br>From: "Hardy, Elaine" <<a href="mailto:ehardy@georgialibraries.org">ehardy@georgialibraries.org</a>><br>Subject: [OPEN-ILS-GENERAL] Question about MARC Batch edit<br><br><br>We are exploring options for adding a $z and a string of $9s to an 856 on<br>title records for Overdrive titles within the PINES consortium. The 856<br>for the specific url for each title will be provided by a vendor. Each<br>record will have a different 856 |u for the Overdrive url since it links<br>to the specific title. We want to take the provided 856 that will look<br>like:<br><br><br>856 40 ?u<br><a href="http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C">http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C</a><br>E-52E4F7B811D5 ?z Access Georgia Download Destination?<br><br><br>And make it look like:<br><br><br>856 40 ?u<br><a href="http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C">http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C</a><br>E-52E4F7B811D5 ?z Access Georgia Download Destination ?z (Patrons of<br>participating GADD libraries please click here). ?9 ARL ?9 CHRL ?9 CRLS ?9<br>CPRL ?9 DTRL ?9 DCPL ?9 ECGR ?9 ECPL ?9 FRRLS-FA ?9 FRRLS ?9 HCLS ?9 HOU<br>?9 LBRL ?9 OCRL-DUBLN ?9 LEE ?9 MRLS ?9 OHOOP ?9 RML ?9 SHRL ?9 SGRL ?9<br>SWGRL ?9 STRL ?9 TCPLS ?9 THRL ?9 TLLS ?9 WORTH<br><br><br>Or (only one subfield z)<br><br><br>856 40 ?u<br><a href="http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C">http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808-A6C</a><br>E-52E4F7B811D5 ?z Access Georgia Download Destination (Patrons of<br>participating GADD libraries please click here). ?9 ARL ?9 CHRL ?9 CRLS ?9<br>CPRL ?9 DTRL ?9 DCPL ?9 ECGR ?9 ECPL ?9 FRRLS-FA ?9 FRRLS ?9 HCLS ?9 HOU<br>?9 LBRL ?9 OCRL-DUBLN ?9 LEE ?9 MRLS ?9 OHOOP ?9 RML ?9 SHRL ?9 SGRL ?9<br>SWGRL ?9 STRL ?9 TCPLS ?9 THRL ?9 TLLS ?9 WORTH<br><br><br>If we use MARC batch edit to add our information, can we add it to the<br>specific Overdrive linked 856 in the desired records and not to all 856s<br>in a record? If so, how would we do that?<br><br>Elaine<br><br>J. Elaine Hardy<br>PINES Bibliographic Projects and Metadata Manager<br><br>Georgia Public Library Service,<br>A Unit of the University System of Georgia<br>1800 Century Place, Suite 150<br>Atlanta, Ga. 30345-4304<br>404.235-7128<br>404.235-7201, fax<o:p></o:p></span></p></div></div></body></html>