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]