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]