That sounds like a great solution to me, Lisa. One question, and please excuse me if it betrays my ignorance: now do I normalize the 505? Does that mean it strips out all the formatting and subfields, etc.?
Thanks!
Chris
-----Original Message-----
From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of Lisa Hatt
Sent: Friday, October 1, 2021 12:58 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] length of field
On 10/1/2021 10:24 AM, Fox, Chris wrote:
> Hi everyone, Is there a way to extract a set of records based on
> length of a field? I've got a file of records that, when I ran it
> through Validate Record Structure it indicated that I have lots of
> 505 fields that are too long. I'd like to get rid of these 505s
> without deleting the ones that are a normal, acceptable length.
I don't know if there's a way to do this directly, but an inelegant workaround perhaps... I do manual editing of long 505s, and what I do to detect them is export tab-delimited of the 001 and the normalized 505 and import that into Excel. Then in the third column I use the formula
=LEN(B2) (etc, fill down) which calculates the character length of the
505 field. Then I can sort by that length and find the ones that are over a certain threshold. If you wanted you could then take the relevant identifiers from the first column back into a text file to use as a FILE search in Extract Selected Records.
--
Lisa Hatt
Cataloging | De Anza 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]
________________________________________________________________________
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]
|
