Thank-you Andy, the first regex you cited worked perfectly. I tried the second one too but found that microfilm wasn't always spelled correctly in the records. I will look at the link you sent me, regular expressions are so handy but I've always struggled with them.
Thank-you again. Lisa S.
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Andy Helck
Sent: Friday, November 26, 2010 9:45 AM
To: [log in to unmask]
Subject: Re: Need regular expression to remove ending period
Hi Lisa,
There are probably several ways to solve your problem, here is one way:
use Find/Replace. make sure to select regular expressions.
Find =949 \\(.*)\.
Replace =949 \\$1
I am on my ibook right now, so I didn't actually test this in MarcEdit against your examples, but here is why it should work. the "=949 \\" part matches all your examples below and will prevent us from taking periods off of 908 fields, etc. the "(.*)" part searches for any char, repeated 0 or more times, and saved in a "capture group". Finally, the "\." says that we want one example at the very end of a real "." character - the period.
In the replace field, we start with the same prefix "=949 \\", followed by the contents of the first capture group, "$1" and with no additional characters at the end of the string.
As I say, normally I would test this solution before sending it to you, but I am not near my desktop at the moment. Give it a try and see what happens.
Here is useful link: http://msdn.microsoft.com/en-us/library/e347654k(v=VS.71).aspx
Yours,
Andy Helck
Wilkinson Public Library
Telluride CO 81435
________________________________________
From: MarcEdit support in technical and instructional matters [[log in to unmask]] On Behalf Of Lisa Stienbarger [[log in to unmask]]
Sent: Thursday, November 25, 2010 8:33 PM
To: [log in to unmask]
Subject: [MARCEDIT-L] Need regular expression to remove ending period
Hello,
Can someone help with a regular expression? I have to remove the ending period from over 9,000 field 949s (we created the 949 field with data from the 830 to map to our holding records) and there are several variations of the text, here are some examples.
=949 \\$jMicrofilm G703 reel 906, no. 7541.1.
=949 \\$jMicrofilm G703 6235.1.
=949 \\$jMicrofilm G703 reel 291, no. 1959.
Any help would be greatly appreciated. Thank-you, Lisa S.
--
Lisa M. Stienbarger
Serials Cataloging Unit, ERSA
Univ. of Notre Dame Libraries
(574) 631-4631
[log in to unmask]<mailto:[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]
|