The subfield editor is a valid alternative; however, in the advent you have
dashes included in any parentheses following the ISBN, those dashes may be
inadvertently removed with this approach. This may not be an issue depending
on whether your ISBNs have parentheses suffixed or, if they do have
parentheses, the degree of importance you attribute to preserving the
structure of their content.
Some examples include: (e-book), (acid-free paper), (e-reference), (e-isbn),
(pbk., companion cd-rom), etc.
On another note, Pat was kind enough to let me know that the first set of
regular expressions I posted did not find any matches in her file although she
was able to find a workable solution by modifying the column format in Excel
prior to pulling them into MarcEdit. The posted regular expression was written
to address a particular group of ISBNs that shared a common digit structure;
however, they did not factor in varying hyphen location within the ISBN
number. The regular expression posted below, while less concise, should
accommodate typical variance in hyphen location. The only caveat is that the
13-digit ISBN regex must be run first, followed by the 10-digit ISBN regex.
13-Digit ISBN RegEx:
Find what: (=020.{4})(\$a[\d])(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)
(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?([\s]?
\(?.*)
Replace with: $1$2$4$6$8$10$12$14$16$18$20$22$24$26$27$28
10-Digit ISBN RegEx:
Find what: (=020.{4})(\$a[\d])(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)
(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?(\d)(\W)?([\s]?\(?.*)
Replace with:
$1$2$4$6$8$10$12$14$16$18$20$21$22
Also, if the records’ 020s happen to feature both subfields “a” and “z”, it is
worth noting that it would be necessary to modify the command in order to
address each. To do this in the subfield editor application, simply change the
subfield entry from “a” to “z”. To do this using RegEx, you would change
the “$a” in the second element of both 13-digit and 10-digit strings to “$z”.
E.g., (\$a[\d]) --> (\$z[\d])
Best,
Zach
Zach Valdes
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]
|