MARCEDIT-L Archives

October 2020

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Lisa Hatt <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Thu, 15 Oct 2020 17:20:31 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (47 lines)
On 10/15/2020 1:23 PM, Chanel Wheeler wrote:

> So we have something like this: =245  10$aTroubles in
> paradise$h[eBook] :$bParadise series, book 3/$cElin Hilderbrand.
> 
> And I remove this: :$bParadise series, book 3
> 
> I can't remove the $b subfield from all the records because there are
> lots that are valid. So is there a way to remove everything between
> "]" and "/" when the word "series" is present?

In matters of regex I am only an egg (to quote Stranger in a Strange 
Land), so do not invest undue confidence in this suggestion, but this 
worked for me tested on your sample data in http://secure-web.cisco.com/1dUDv55lnPKHGfmSJaDVA4FBo3JzEaCTMOKWwMDH5t-pDQjb9S5tr9vGz0atoYHz55be02Tktb8ue2sCio9jNQjZRrERyJQ83GMJlUp8VAAUYQQnEvklbCdtxXMwT1NcSu1tcnvPEH5KDSTU6ZyfeqLazd-qXf0dVyzpV8JBPJiNN-BIjNvYBmtREuPlHEk4bIaeQyas2NWCGcZKBU2Fe9VLDVt01ZdBC1TCXdB5JY8uOi0gcwTJuRh5zokVKTq52wSd2f5TiOl7wWXBWgfjbOtYPmahN5c-MWJVWORFNIyowFag0KbWi1j8GKgKJwGtViY2ULwyU6gcOwdrQu6ujthWhBnJQ4KY7Pvluqzm01pbtX3O6DVdweDjQ64P1Q51A2s4BVvEl2tslwZhC3IFwJyeILVwQAufiTlPAB7Mm34dGVLRwE1YUJiW8Tf2kTRgMcQJNt-aIRtSvO_GdVdmWiA/http%3A%2F%2Fregexstorm.net%2Ftester%3A

Find

:\$b.*series.*/\$c

Replace with

/$c

So,

=245  10$aTroubles in paradise$h[eBook] :$bParadise series, book 
3/$cElin Hilderbrand.

becomes

=245  10$aTroubles in paradise$h[eBook] /$cElin Hilderbrand.

(Your sample doesn't have a space before the slash but normally I would 
expect one there. If you really want to close that up, add a space to 
the beginning of the "find" expression.)

I would use Edit Field Data rather than a general find-replace.

-- 
Lisa Hatt
Cataloging | DeAnza College Library
[log in to unmask] | 408-864-8459

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

ATOM RSS1 RSS2