On Thursday, June 25, 2015 3:01 PM, Chris Fox wrote:
>I've got a file of records which has lots of sub-par records among many more good ones. I'd like to remove the bad ones. Is there a way to remove a set of records based on the Encoding Level (Leader/17) and/or the Descriptive Cataloging Form (Leader/18) from this file? I've tried using the Select Individual Record(s) to Make tool, but there is no position number search option for LDR, and since there's no way to make a search case-sensitive, I can't do it that way either. I also tried using the Does Not Match option to exclude all the encoding levels of the good records, but I couldn't make that work.
In Select Individual Record(s) to Make
Display field: LDR
Search: ^.{17}[35Km]i
Use regular expressions.
In the Search, the "^" says to start at the beginning of the field; .{17} finds anything within the first 17 characters/bytes, then put the codes you want to find within []--in this case, level-3, level-5, and level-K, along with hypothetical level-m. The i following the bracketed encoding levels could be another bracketed list of Cataloging forms--[abc] would select any record with LDR/18 of either 'a', 'b', or 'c'.
Of course, you may want to do the selecting for /17 vs. /18 in separate searches, in which case, you would do "^.{17}[]" (with desired values in []) for the /17, then "^.{18}[]" for /18.
I hope this helps,
Bryan Baldus
Senior Cataloger
Quality Books Inc.
The Best of America's Independent Presses
1-800-323-4241x402
[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]
|