View Single Post
 
Old 12-10-2012, 05:33 AM
grapes grapes is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Dec 2012
Posts: 6
grapes is on a distinguished road
Default Problem with find and replace

Hello this is my situation. I have a very long text which contains a lot of references. Here is a example:


Microsoft Windows is a series of graphical interface (Jhon Smith, 1986). operating systems developed, marketed, and sold by Microsoft (Richard Hale, 1946 and Jhon Smith, 1990).

So I need a formula which can find and delete any string of characters between parentheses, but which also must contain a 4 digit number (a year date which always starts with 19). To make things easier (because () are wildcard characters) i changed the ( for Ö, and the ) for Ü in all the document.
I tried different things, like Ö*[0-9]{4}*Ü, but i get always the same problem, it does not select one by one:

Microsoft Windows is a series of graphical interface (Jhon Smith, 1986) operating systems developed, marketed, and sold by Microsoft (Richard Hale, 1946 and Jhon Smith, 1990).

Any help will be appreciated and sorry about my bad english.
Reply With Quote