It works beautifully! Thanks Andy.
So far all the records start with EE, so I tried with the first one. But I can see the value of the second one for other cases when uppercase letters vary.
Thanks,
Iris
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Andy Helck
Sent: Thursday, January 13, 2011 10:58 AM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] Need regular expression to remove letters in 001 field
Hi Iris,
you can differentiate between upper case and lower case letters by specifying character classes: [A-Z] vs. [a-z]
But if you always have the EE starting off the field, its even easier. Here are a couple of ways you might get the job done using Find and Replace with Regular Expression box checked.
Find: =001 EE[a-z]*([0-9]*)
Replace: =001 EE$1
the above assumes its always EE that starts the field. If you want to allow any group of uppercase letters to stay, try the following:
Find: =001 ([A-Z]*)[a-z]*([0-9]*)
Replace: =001 $1$2
I'm on my Mac right now so I can't actually test these directly, but they should be pretty close to something that will work.
Yours,
Andy Helck
Wilkinson Public Library
Telluride CO 81435
________________________________________
From: MarcEdit support in technical and instructional matters [[log in to unmask]] On Behalf Of Liu, Iris [[log in to unmask]]
Sent: Thursday, January 13, 2011 6:39 AM
To: [log in to unmask]
Subject: [MARCEDIT-L] Need regular expression to remove letters in 001 field
Hello,
Can someone help with a regular expression? I have to remove the letters in 001 field in between letters and numbers:
=001 EEsmithadam0003178
=001 EEabarcpedro000018
=001 EEabauzfirmi000019
I¡¯d like to get rid of the lower case letters in between ¡°EE¡± and numbers:
=001 EE0003178
=001 EE000018
=001 EE000019
Any help would be greatly appreciated.
Thanks,
Iris Liu
Áõæµ
Cataloguing Librarian, Bibliographic Control Services
Queen Elizabeth II Library
Memorial University of Newfoundland
St. John's, NL A1C 5S7
Tel. : 709-864-8023
E-mail: [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]
________________________________________________________________________
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]
|
