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:
"Hults, Patricia" <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Fri, 16 Nov 2012 20:25:35 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (59 lines)
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]

ATOM RSS1 RSS2