Using wildcards (Like -operator)
When a value supports wildcards (Like -operator) you can use the following special characters. All of the example below match the string ‘example 1’.
| Character | Description | Example |
|---|---|---|
| * | Zero or more characters | *amp*1 |
| ? | Any single character | e?ample 1 |
| # | Any single digit (0–9) | example # |
[charlist] | Any single character in charlist | e[xyz]ample 1 |
[!charlist] | Any single character not in charlist | e[!abc]ample 1 |
To match the special characters left bracket ([), question mark (?), number sign (#), and asterisk (*), enclose them in brackets. The right bracket (]) cannot be used within a group to match itself, but it can be used outside a group as an individual character.