At 08:25 PM 11/16/2012 +0000, Hults, Patricia wrote:
>Wow! I'm running out the door, but will try it over the weekend. This is
>a great listserv! -
Alternatively (for both 10 and 13 ISBNs), select the whole column in your
spreadsheet and:
a) format => cells => "Custom" => ############# (13 hashes)
b) <CTRL>+<H> (I think MS calls that "replace"), first box type '-'
(without quotes), leave second box blank, <ENTER>
Best - Paul
---
Paul Adamthwaite, Ph.D.
Executive Director
---
Naval Marine Archive : The Canadian Collection
205, Main Street, Picton, Ontario, K0K 2T0, Canada
Telephone: 1 613 476 1177
http://navalmarinearchive.com and http://ultramarine.ca
Canadian Charitable Organization 88721 9921 RR0001
>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]
|