[OPEN-ILS-GENERAL] Question about MARC Batch edit

Fri May 18 13:59:14 EDT 2012

Hi Mike,

OK, I'm still having trouble. I left off the "/" at either end, and entered
my string as ^NMLSYS$. All the subfields 9 were deleted, not just the one
I'm trying to target. I'm back where I started. 

I'm sure once I get it, it will seem so easy. But right now, I'm totally
lost.

Mary

-----Original Message-----
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Mike Rylander
Sent: Friday, May 18, 2012 1:32 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Question about MARC Batch edit

On Fri, May 18, 2012 at 11:59 AM, Ian Bays <ian.bays at ptfs-europe.com> wrote:
> If you are trying to match exactly NMLSYS your regular expression 
> should probably be:
> /^NMLSYS$/
> The // being the start/end of the regular expression, the ^ being the 
> start of the field being searched and the $ being the end of that field.

While the anchors (^ and $) might be useful, the /s are not.  The value
entered is the regexp itself, not the Perl syntax to construct it.  IOW, we
take what you give us, escape some of it for sanity and safety, and then use
qr// to construct a regexp object in Perl.

--miker

>
> I can't say I have tried that feature, but that's the regular expression.
> Try it.
>
> Ian
>
>
> On 18/05/2012 16:31, Mary Llewellyn wrote:
>
> 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.
>
> 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!
>
> I set it up as
>
> Action (Rule type): Delete
>
> MARC tag: 856
>
> Subfields: 9
>
> Advanced Matching Restriction:
>
> Subfield: 9
>
> Regular Expression: NMLSYS
>
> 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.
>
> Any help would be greatly appreciated.
>
>
>
> From: open-ils-general-bounces at list.georgialibraries.org
> [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf 
> Of Katie Wallis
> Sent: Friday, April 20, 2012 12:25 PM
> To: open-ils-general at list.georgialibraries.org
> Subject: Re: [OPEN-ILS-GENERAL] Question about MARC Batch edit
>
>
>
> Hi Elaine,
>
> 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:
>
>
>
> Action (Rule Type): Add
>
> MARC tag: 856
>
> Subfields (option): z9
>
> MARC Data: 856 \\$z (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
>
>
>
> Advanced Matching Restrictions
>
> Subfield: z
>
> Regular Expression: Access Georgia Download Destination
>
> Katie
>
>
>
>
>
>
>
>
> Katie Wallis
>
> Columbia Gorge Community College Library
>
> 400 East Scenic Drive, The Dalles, OR 97058
>
> kwallis at cgcc.cc.or.us | 541-506-6087
>
>
>
>>>> <open-ils-general-request at list.georgialibraries.org> 4/20/2012 9:00 
>>>> AM
>>>> >>>
>
>    1. Question about MARC Batch edit (Hardy, Elaine)
>
>
> Date: Thu, 19 Apr 2012 14:04:47 -0400 (EDT)
> From: "Hardy, Elaine" <ehardy at georgialibraries.org>
> Subject: [OPEN-ILS-GENERAL] Question about MARC Batch edit
>
>
> We are exploring options for adding a $z and a string of $9s to an 856 
> on title records for Overdrive titles within the PINES consortium. The 
> 856 for the specific url for each title will be provided by a vendor. 
> Each record will have a different 856 |u for the Overdrive url since 
> it links to the specific title. We want to take the provided 856 that 
> will look
> like:
>
>
> 856  40  ?u
> http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808
> -A6C
> E-52E4F7B811D5 ?z Access Georgia Download Destination?
>
>
> And make it look like:
>
>
> 856  40  ?u
> http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808
> -A6C
> E-52E4F7B811D5 ?z Access Georgia Download Destination ?z (Patrons of 
> participating GADD libraries please click here). ?9 ARL ?9 CHRL ?9 
> CRLS ?9 CPRL ?9 DTRL ?9 DCPL ?9 ECGR ?9 ECPL ?9 FRRLS-FA ?9 FRRLS ?9 
> HCLS ?9 HOU
> ?9 LBRL ?9 OCRL-DUBLN ?9 LEE ?9 MRLS ?9 OHOOP ?9 RML ?9 SHRL ?9 SGRL 
> ?9 SWGRL ?9 STRL ?9 TCPLS ?9 THRL ?9 TLLS ?9 WORTH
>
>
> Or (only one subfield z)
>
>
> 856  40  ?u
> http://GADD.lib.overdrive.com/ContentDetails.htm?ID=CE3E7B9F-22CB-4808
> -A6C
> E-52E4F7B811D5 ?z Access Georgia Download Destination (Patrons of 
> participating GADD libraries please click here). ?9 ARL ?9 CHRL ?9 
> CRLS ?9 CPRL ?9 DTRL ?9 DCPL ?9 ECGR ?9 ECPL ?9 FRRLS-FA ?9 FRRLS ?9 
> HCLS ?9 HOU
> ?9 LBRL ?9 OCRL-DUBLN ?9 LEE ?9 MRLS ?9 OHOOP ?9 RML ?9 SHRL ?9 SGRL 
> ?9 SWGRL ?9 STRL ?9 TCPLS ?9 THRL ?9 TLLS ?9 WORTH
>
>
> If we use MARC batch edit to add our information, can we add it to the 
> specific Overdrive linked 856 in the desired records and not to all 
> 856s in a record? If so, how would we do that?
>
> Elaine
>
> J. Elaine Hardy
> PINES Bibliographic Projects and Metadata Manager
>
> Georgia Public Library Service,
> A Unit of the University System of Georgia
> 1800 Century Place, Suite 150
> Atlanta, Ga. 30345-4304
> 404.235-7128
> 404.235-7201, fax
>
>
> --
> Ian Bays
> Director of Projects, PTFS Europe Limited Content Management and 
> Library Solutions
> +44 (0) 800 756 6803 (phone)
> +44 (0) 7774 995297 (mobile)
> +44 (0) 800 756 6384 (fax)
> skype: ian.bays
> email: ian.bays at ptfs-europe.com

--
Mike Rylander
 | Director of Research and Development
 | Equinox Software, Inc. / Your Library's Guide to Open Source
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com