AVEVA Clash Manager™ 14.3
User Guide
Entry Information
: Notes on Wildcards
Notes on Wildcards
AVEVA Clash Manager uses two different styles of wildcards:
•
In the configuration, standard Regular Expression syntax is used exclusively.
•
In the UI filters, Oracle/SQLServer style wildcards ( "%" and "_" ) are used exclusively.
Regular Expression Summary
Value
Meaning
^
Matches the start of a line
$
Matches the end of a line
.
Matches any character
*
Matches zero or more occurrences of the previous expression
[string]
Matches any one of the characters listed in string
In addition to the standard Regular Expression syntax there is a simple NOT operator <
!
>. If the exclamation mark is the first character of the Regular Expression, the rule evaluates TRUE if the expression fails.
Examples of Regular Expression Syntax
Example Expression
Matches
Result of Example Expression
^[AB]305$
A string beginning with ‘A’ or ‘B’ and ending with ‘305’
A305 or B305
[AB]305
A string containing ‘A’ or ‘B’ followed by ‘305’
IBM
A305
HAL or
PQR
B305
LMN
!TEMP45
Any string that does NOT contain ‘TEMP45’
/THIS/string/Matches
^/S45/.*/TEMP45$
A string beginning /S45 and ending with TEMP45
/S45/ABCanythinggoeshere 345/TEMP45
!^/S45
Any string that does not begin with /S45
Oracle/SQLServer Wildcard Summary
Value
Meaning
%
Any number of characters of any value
_
Each underscore represents a single character of any value
Examples of Oracle/SQLServer Wildcard Syntax
Example Expression
Matches
%pipe%
Any string of any number of characters that contains 'pipe'
pipe_
Any string that starts 'pipe' and ends with a single character
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.