Perhaps a more reliable plan would be to add qualifiers to the purely numeric 035s you want to keep, using whatever "if" statements ((or "extract" criteria) apply?
Then you could delete the remainder.
DougR
Sent from my mobile, which is solely responsible for all nonsensical auto-corrections.
> On Sep 27, 2016, at 9:13 AM, Terry Reese <[log in to unmask]> wrote:
>
> I'll take a look at this in an hour so.
>
> -----Original Message-----
> From: MarcEdit support in technical and instructional matters
> [mailto:[log in to unmask]] On Behalf Of Foster, Meredith
> Sent: Tuesday, September 27, 2016 9:54 AM
> To: [log in to unmask]
> Subject: Re: [MARCEDIT-L] Removing an 035 if it matches the 001
>
> There is no qualifying string, which is the problem for migration.
> Voyager's server-side bulk import process will always create an 035 out of
> the 003+001, but in this case (authority cleanup), the records were
> extracted, so there is no 035 and the 001 is the BIBID. It appears it's an
> option that cannot be disabled in Voyager, which is why I now use Gary
> Strawn's client-side batch tools instead.
>
> I included a sample to show what they look like:
>
> =LDR 00872cam a2200253 a 4500
> =001 10485
> =005 20020926110850.0
> =008 810119m19531957enka\\\\\b\\\\00110\engm\
> =035 \\$a(OCoLC)07068986
> =035 \\$9AAB0661WC
> =035 \\$a10485
> =040 \\$aDLC$cZYU$dZYU$dQWC
> =049 \\$aQWCC$v1 [96732]$v1 c.2 [102968]$v1 c.3 [365442]$v2 [96733]$v2 c.2
> [102969]$v2 c.3 [365443]
> =050 0\$aDA356$b.N4
> =082 \\$a942.055
> =092 \\$a942.055$bE43xn
> =100 1\$aNeale, J. E.$q(John Ernest),$d1890-1975.
> =245 10$aElizabeth I and her Parliaments /$cJ.E. Neale.
>
> The second 035 is the old NOTIS ID number which is fine to keep as well,
> it's the third 035 that we may have to eliminate to avoid any problems with
> the migration. I have ~500,000 more with unqualified all-numeric 035's,
> mostly this particular issue (but some are Films on Demand numbers, we now
> add an 003 during batch editing prior to load to avoid that issue).
>
> -----Original Message-----
> From: MarcEdit support in technical and instructional matters
> [mailto:[log in to unmask]] On Behalf Of Terry Reese
> Sent: Tuesday, September 27, 2016 9:36 AM
> To: [log in to unmask]
> Subject: Re: [MARCEDIT-L] Removing an 035 if it matches the 001
>
> Couple questions -- the 035 generally has a qualifying string -- is this the
> case with this data? My guess, using the multi-line processing, you could
> likely trap the 001, then the data to the qualifying data, and then us a
> backreference to compare the data in the 035 to the data in the 001 -- but
> before I could give you any kind of example, I'd need to be more familiar
> with the data. The problem with the multi-line replacement options is that
> you have to be very careful in making sure that whatever data you process
> and trap, you handle or put back. Otherwise, you can quickly delete a lot
> of record data.
>
> --tr
>
> -----Original Message-----
> From: MarcEdit support in technical and instructional matters
> [mailto:[log in to unmask]] On Behalf Of Foster, Meredith
> Sent: Tuesday, September 27, 2016 7:49 AM
> To: [log in to unmask]
> Subject: [MARCEDIT-L] Removing an 035 if it matches the 001
>
> My library is migrating from Voyager to Alma, and one of the things we may
> have to do is remove the excess 035's that simply contain the Voyager BIBID.
> Alma will generate a properly tagged version of the Voyager BIBID for future
> reference, so the extra 035 is not needed. They get added whenever a group
> of records is exported, modified in some way, then overlaid based on the
> BIBID in the 001 tag, such as our monthly authority cleanups through
> MARCIVE.
>
> What I would like to do is devise a replace or a delete field rule that will
> remove an 035$a if it has the exact same number in the 001. I tried various
> "replace if" setups, but was unable to find a solution. I assume it would
> require a multiline regex lookahead, but I don't know how to write one
> properly.
>
> Does anyone have a solution to this issue?
>
> ________________________________________________________________________
>
> 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]
>
> ________________________________________________________________________
>
> 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]
>
> ________________________________________________________________________
>
> 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]
>
> ________________________________________________________________________
>
> 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]
________________________________________________________________________
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]
|