Last updated: Jan 17, 2024
In the Expression Builder, you can search for fields, values, or functions.
For example, to search for a value, place your cursor in the Find in column Value field and enter the text you want to search for.
You can also search on special characters such as tabs or newline characters, classes or ranges of characters such as a through d, any digit or non-digit, and boundaries such as the beginning or end of a line. The following types of expressions are supported.
| Characters | Matches |
|---|---|
| x | The character x |
| \\ | The backslash character |
| \0n | The character with octal value 0n (0 <= n <= 7) |
| \0nn | The character with octal value 0nn (0 <= n <= 7) |
| \0mnn | The character with octal value 0mnn (0 <= m <= 3, 0 <= n <= 7) |
| \xhh | The character with hexadecimal value 0xhh |
| \uhhhh | The character with hexadecimal value 0xhhhh |
| \t | The tab character ('\u0009') |
| \n | The newline (line feed) character ('\u000A') |
| \r | The carriage-return character ('\u000D') |
| \f | The form-feed character ('\u000C') |
| \a | The alert (bell) character ('\u0007') |
| \e | The escape character ('\u001B') |
| \cx | The control character corresponding to x |
| Character classes | Matches |
|---|---|
| [abc] | a, b, or c (simple class) |
| [^abc] | Any character except a, b, or c (subtraction) |
| [a-zA-Z] | a through z or A through Z, inclusive (range) |
| [a-d[m-p]] | a through d, or m through p (union). Alternatively this could be specified as [a-dm-p] |
| [a-z&&[def]] | a through z, and d, e, or f (intersection) |
| [a-z&&[^bc]] | a through z, except for b and c (subtraction). Alternatively this could be specified as [ad-z] |
| [a-z&&[^m-p]] | a through z, and not m through p (subtraction). Alternatively this could be specified as [a-lq-z] |
| Predefined character classes | Matches |
|---|---|
| . | Any character (may or may not match line terminators) |
| \d | Any digit: [0-9] |
| \D | A non-digit: [^0-9] |
| \s | A white space character: [ \t\n\x0B\f\r] |
| \S | A non-white space character: [^\s] |
| \w | A word character: [a-zA-Z_0-9] |
| \W | A non-word character: [^\w] |
| Boundary matchers | Matches |
|---|---|
| ^ | The beginning of a line |
| $ | The end of a line |
| \b | A word boundary |
| \B | A non-word boundary |
| \A | The beginning of the input |
| \Z | The end of the input but for the final terminator, if any |
| \z | The end of the input |