MARCEDIT-L Archives

November 2012

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Fri, 16 Nov 2012 16:51:36 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (88 lines)
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]

ATOM RSS1 RSS2