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:
Zach Valdes <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Fri, 16 Nov 2012 14:48:54 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (44 lines)
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