Hi Meredith,
If I'm reading your messages correctly, wouldn't it be sufficient to look for an 035 that DOES NOT contain any alpha characters and delete them and only them?
I'm guessing Add/Delete Field Utility, Field 035, Field Data:
[regular expression for NOT any a-z or A-Z]
Click on Use Regular Expression
Click on Delete Field
I would think this would work if all the OCLC 035s contain the standard (OCoLC) prefix, all the old NOTIS IDs contain at least one alpha character, and none of the BIBIDs contain an alpha character.
Or am I misunderstanding the desired outcome?
Thanks,
Jeff
----- Original Message -----
From: "Foster, Meredith" <[log in to unmask]>
To: [log in to unmask]
Sent: Tuesday, September 27, 2016 9:53:52 AM
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]
|