Thread: [Solved] Wildcards: searching for multiple words / expressions close to each other
View Single Post
 
Old 11-08-2017, 12:57 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,367
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Quote:
Originally Posted by ballpoint View Post
As a follow-up question, is a Word / Office wildcard cheatsheet available somewhere? Most of the documentation I have found was a little fragmented.
See:
https://support.office.com/en-us/art...4-7708c6c779b7
http://www.gmayor.com/replace_using_wildcards.htm
Quote:
Originally Posted by ballpoint View Post
Beyond that, I also wonder if it would not be possible to use something like the Fuzzy Lookup addin (https://www.microsoft.com/en-us/down....aspx?id=15011) for something like this.
I don't know of a fuzzy-match addin for Word. That said, using VBA there are numerous additional matching options available, including:
• IgnorePunct - ignores punctuation in found text
• IgnoreSpace - ignores extra white space in found text
• MatchAllWordForms - (also available via the GUI) finds all forms of the find text, e.g. if the text to find is "sit," "sat" and "sitting" are also found
• MatchPhrase - ignores all white space and control characters between words
• MatchPrefix - matches words starting with the search string
• MatchSoundsLike - (also available via the GUI) matches words that sound similar to the text to find
• MatchSuffix - matches words ending with the search string
• MatchWholeWord - (also available via the GUI) matches only entire words
These don't all work with wildcards and I've rarely needed to call on any of them. YMMV
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote