Yeah -- I was curious if your data was all one type. You could create custom expressions per type -- it wouldn't be that difficult.
--tr
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Myers, John F.
Sent: Tuesday, June 4, 2013 2:08 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] Repairing Records?
Thanks Terry! I might have figured out the RegEx on my own, but not without considerable pain and frustration, particularly given my frame of mind at the moment. (Grabbing lunch helped considerably on that front too.)
(Although I now realize that the length of the 007 is dependent on the coding -- but pruning to 14 does not seem to have over-truncated the data, and what is left is manageable.)
John F. Myers, Catalog Librarian
Schaffer Library, Union College
Schenectady NY 12308
[log in to unmask]
518-388-6623
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Terry Reese
Sent: Tuesday, June 04, 2013 12:56 PM
To: [log in to unmask]
Subject: Re: Repairing Records?
The repair function is specific for structural issues. The 007/006 lengths are MARC21 specific -- so MarcEdit won't automatically deal with those. However, if you are just looking to truncate data -- you could use something like this:
Find: (=006.{2}.{18})(.*)
Replace: $1
Check regular expression option
* This keeps just the first 18 bytes
Find: (=007.{2}.{14})(.*)
Replace: $1
Check Regular Expressions
*This just keeps the first 14 bytes
--tr
On Tue, Jun 4, 2013 at 12:46 PM, Myers, John F. <[log in to unmask]> wrote:
> My ILS is doing something wonky to the lengths of our 006 and 007 fields when I roundtrip the records to our authority vendor (I've confirmed it's the ILS doing something when I pull them from it). I recall there is something in MarcEdit that can attempt to repair minor formatting issues. I'm sufficiently wigged out at the moment that I can't remember where it is in the program. I've already done a basic Break and Make cycle to see if that would clean things up, without success. Is there an explicit function to access? Failing that, can a RegEx guru provide me a way to truncate the 006 and 007 to their proper lengths of 18 and 14 characters from the 44 that seem to have propagated themselves into the file?
>
> Many thanks, from a flustered,
>
> John F. Myers, Catalog Librarian
> Schaffer Library, Union College
> Schenectady NY 12308
>
> [log in to unmask]
> 518-388-6623
>
> ______________________________________________________________________
> __
>
> 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]
|