Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-17-2021, 09:47 AM
rekent rekent is offline VBA wildcard search that only identifies results that do not follow delineated words Windows 10 VBA wildcard search that only identifies results that do not follow delineated words Office 2016
Novice
VBA wildcard search that only identifies results that do not follow delineated words
 
Join Date: May 2014
Posts: 23
rekent is on a distinguished road
Default 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?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Wildcard Search gmaxey Word VBA 4 07-12-2020 05:13 PM
VBA wildcard search that only identifies results that do not follow delineated words Word VBA wildcard search - odd results MikeForward Word VBA 3 02-21-2019 06:18 AM
Change characters outside a wildcard while keeping wildcard results nymusicman Word VBA 2 04-10-2014 08:17 AM
2013 search results take a long time - they fill in as results in reverse date order themookman Outlook 0 10-11-2013 12:01 PM
Wildcard search help. Kempston Word 0 11-13-2009 03:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft