Regular expressions

Regular expressions in TQL allow you to create flexible search patterns to match text within field values. They help locate data based on whether a string appears at the start, end, or anywhere within the value.

The following table lists commonly used regular expression patterns and describes how they are applied in TQL searches.

Pattern	Operation performed
`:Begin*`	Matches values that start with Begin. The asterisk (`*`) acts as a wildcard for any subsequent characters.
`:/.temp./`	Matches values that contain the string temp anywhere in the field. The `.*` expression allows any characters (including spaces) to appear before or after the string.
`:/.*End/`	Matches values that end with End. The leading `.*` indicates that any characters may appear before the target string.
`:/.sub string./`	Matches values that contain the phrase substring, including instances with spaces or other characters surrounding it.