Regular expressions are characters that customize a text search string. They formulate a more complex search.
You must select the Regular expression checkbox to use these advanced search features.
| Type of Search |
Search Characters |
Location of character in the search string |
Explanation | ||||||||
|
Text at the beginning of line |
^ (circumflex) Example:^select |
Beginning | A circumflex at the beginning of the text search string finds the text only if it is the first non white space text on a line | ||||||||
|
Text at the end of line |
$ (dollar sign) Example:error$ |
End | A dollar sign at the end of the expression matches the end of a line. | ||||||||
|
Single character wildcard |
. (period) Example:f.r matches "for" and "‘far" |
Any place | A period represents any character. | ||||||||
|
Class of character |
: (colon) Example:SQL:a finds SQLSTATE or SQLTABLE SQL:d Finds SQL1 or SQL3 |
Any place |
A colon matches a class of characters described by the character following the colon.
| ||||||||
|
Search for Regular Expression characters |
\ (backslash) Example: \^ searches for ^ \\ searches for \. |
Any place | A backslash before a wildcard character searches for actual character and does not use the character as a wildcard. | ||||||||
|
Search for multiple characters in one position |
[...] (characters within square brackets Example:r[au]n finds run or ran |
Any place | Characters enclosed in square brackets matches any one character that displays in the brackets, but no others. Nesting of brackets is not supported. | ||||||||
|
Search for any character but the specified characters in one character position |
[^] (circumflex within square brackets) Example: r[^oa]n finds run, r n, rin, etc but not ron or ran. |
Any place | A circumflex at the start of the string in square brackets means NOT. The expression matches any character except the characters in the string and the carriage return (ASCII 0x0D) or line feed (ASCII 0x0A). | ||||||||
|
Search for a range of characters in one character position |
[-] (hyphen within the square brackets) Example: SQL[1-3] finds SQL1, SQL2 and SQL3 |
Any place |
A hyphen within the square brackets signifies a range of characters. Note: the range must be in a progressive order, i.e. "[a-x]" matches any character from a through x while "[x-a]" does not match anything. |
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
