The Run with a user form and parameters macro makes use of regular expressions for pattern matching. Generally, just a simple understanding of regular expressions and a few examples are enough to get by for most use cases. This page has a few simple examples to get started. Use the references for more advanced information. It is recommended to test your regular expressions in one of the well-known regex testing sites such as RegexPlanet or Regex101.
|example.txt||Find string not containing a word. In this example, files that do not have a .png extension|
|example.png||Find string not containing a word. In this example, files that do not have a .png extension|
|example.jpeg||Find string not containing a word. In this example, files that do not have a .png or .jpeg extension|
|collateral wholesale retail||Match exact words anywhere in string. In this case, a blank separated list of labels and both collateral and retail must be included for the match to be successful|
|wholesale retail||Both are required for a match|
|merger acquisition||Match string containing either word|
- RegexOne - interactive tutorials to learn how to construct regular expressions
- Regexlib.com - searchable collection of user-contributed regular expressions
- RegexPlanet test site - test your expressions quickly
- Regex101 test site - understand a regex expression and test it
- Wikipedia regular expressions
- Regular expression reference
- Quick reference - best once you have the concepts
- Using word boundaries
- Regular expression to match string not containing a word?