Find

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.

Table 1. Character matches
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
Table 2. Matching character classes
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]
Table 3. Predefined character classes
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]
Table 4. Boundary matches
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