Wow! I'm running out the door, but will try it over the weekend. This is a great listserv! - Pat
Patricia Hults
Manager of Technical Services
Rensselaer Libraries
Rensselaer Polytechnic Institute
110 8th St.
Troy, NY 12180-3590
(518) 276-8358
[log in to unmask]
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Zach Valdes
Sent: Friday, November 16, 2012 2:49 PM
To: [log in to unmask]
Subject: Re: Problem with numbers in delimited text translator
Hi Patricia,
I wrote this ME RegEx for your application. Assuming the placement of ISBN dashes in your file are standard format for both 10 and 13 digit ISBNs, this should accomplish what you are asking. I haven't come across the need to remove hyphens from 020s in MARC records yet but I would not be surprised to encounter this issue at some point.
In the Replace tool, check the "Use regular expressions" box and plug in the
following:
To remove hyphens from 10-digit ISBNs:
Find what: (=020.{4})(\$a[\d])(\W)(\d{6})(\W)(\d{2})(\W)(\d)([\s]?\(?.*)
Replace with: $1$2$4$6$8$9
To remove hyphens from 13-digit ISBNs:
Find what: (=020.{4})(\$a[\d]{3})(\W)(\d)(\W)(\d{6})(\W)(\d{2})(\W)(\d)
([\s]?\(?.*)
Replace with: $1$2$4$6$8$10$11
If you have both 10 and 13-digit ISBNs in your file, you can simply run these two functions one after the other. These regular expressions will also maintain any parentheses note that may currently exist in your 020 following the actual number, i.e., (electronic bk.), (hardback), etc.
Let me know how it works out!
Zach Valdes
Assistant Professor,
E-books & Special Formats Cataloger
Newton Gresham Library
Sam Houston State University
Phone: (936)294-2512
[log in to unmask]
--------------------------------------------------------
Sam Houston State University
A Member of The Texas State University System
________________________________________________________________________
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]
|