How to use Wildcards (Pattern matching) to filter query results
Article ID: 151862
Updated On:
Products
Control Compliance Suite Windows
Issue/Introduction
How to use Wildcards (Pattern matching) to filter query results
Resolution
For example, to query directory names that follow a definite pattern, follow these steps:
The following list cover syntax rules.
Q*1 Matches entries that start with a Q and end with a 1, with any number of characters in between.
S???1 Matches entries that start with an S, have any three characters between, and end with 1.
A Matches “A”, and “a”. Does not match “B”, or “Adef”, etc.
[abc]def Matches “adef”, “bdef” and “cdef”.Does not match anything else.
[a-c]def Matches “adef”, “bdef” and “cdef”.Does not match anything else.
[^a-c]def Does NOT match “adef”, “bdef”, or “cdef”. It does match “ddef”, “edef”, etc. (^ represents the NOT character)
[:alpha:] Matches all cases for all alphabetic characters
[:alnum:] Matches all alphanumeric characters
[:Ntspecialchar:] Matches all valid Windows NT/2000 special characters
[:Ntchar:] Matches all valid characters for a Windows NT/2000 machine name
. Matches any single character one time.
\ This is an escape-sequence character.Any character following “\” will be evaluated literally, not according to its special function within distribution rules.don\.art will result in a match with “don.art” only, and will not match “donxart”.
[a-c]def Matches “adef”, “bdef” and “cdef”. Does not match anything else.
a?def Matches “adef” or “def”.
+ Matches the preceding character one or more times
a{2,3} Matches 2 a’s or 3 a’s, “aa” or “aaa”.
a{3,} Matches “a” three or more times.
a|b Matches “a” or “b”. (“|” means “or”).
a|b?def Matches “adef” or “bdef” or “def”.
abc? Matches “abc” or “ab”.
cat)?95 Matches “95” or “cat95”.
- Launch the RMS Console.
- On the icon bar at the top, click the New Query (red book) icon.
- Expand bv-Control for Windows, then click the Directories data source. Click OK.
- On the Field Specification Tab, add the following fields:
- Domain/Workgroup Name
- Machine Name
- Directory Name(Without path)
- On the Filter Specification Tab, add the field "Directory Name(Without path)". In the Filter Term Definition dialog box, choose 'Matches Pattern'
- Mention the pattern based on the sample values provided below and Click OK
- Click OK. Then click Run and View As Grid.
The following list cover syntax rules.
Q*1 Matches entries that start with a Q and end with a 1, with any number of characters in between.
S???1 Matches entries that start with an S, have any three characters between, and end with 1.
A Matches “A”, and “a”. Does not match “B”, or “Adef”, etc.
[abc]def Matches “adef”, “bdef” and “cdef”.Does not match anything else.
[a-c]def Matches “adef”, “bdef” and “cdef”.Does not match anything else.
[^a-c]def Does NOT match “adef”, “bdef”, or “cdef”. It does match “ddef”, “edef”, etc. (^ represents the NOT character)
[:alpha:] Matches all cases for all alphabetic characters
[:alnum:] Matches all alphanumeric characters
[:Ntspecialchar:] Matches all valid Windows NT/2000 special characters
[:Ntchar:] Matches all valid characters for a Windows NT/2000 machine name
. Matches any single character one time.
\ This is an escape-sequence character.Any character following “\” will be evaluated literally, not according to its special function within distribution rules.don\.art will result in a match with “don.art” only, and will not match “donxart”.
[a-c]def Matches “adef”, “bdef” and “cdef”. Does not match anything else.
a?def Matches “adef” or “def”.
+ Matches the preceding character one or more times
a{2,3} Matches 2 a’s or 3 a’s, “aa” or “aaa”.
a{3,} Matches “a” three or more times.
a|b Matches “a” or “b”. (“|” means “or”).
a|b?def Matches “adef” or “bdef” or “def”.
abc? Matches “abc” or “ab”.
cat)?95 Matches “95” or “cat95”.
Feedback
Yes
No
Powered by
