VBA wildcard search that only identifies results that do not follow delineated words
I am adding a routine to some VBA code to search for instances of a period that is followed by one space and then [0-9A-z] to identify the start of a new sentence. This is being done to identify instances of one space rather than two between sentences.
However, there are some obvious cases such as abbreviations mid-sentence that require periods, Mrs./Mr./etc. and others that will flag using the wildcard search for the above terms but should not have a double space following the period.
Is it possible to condition a wildcard search to only return results if it does not follow a word found on a delineated list of words?
|