Regular Expressions

When you click on a report column with text data (e.g. company or person name, list or tags or labels etc.) and select Filter rows / matches and not matches then you can enter a regular expression that will be used to filter report rows.

Simple match

A simple regular expression is a fragment of a text that you want to match.

Regular expression John will match John Smith or Peter Johnson.

Beginning or end of string

Use ^ to indicate beginning of the string or $ to indicate end of the string.

Regular expression ^John will match John Smith but will not match Peter Johnson.

Regular expression Smith$ will match John Smith but will not match Smith John.

Alternatives

Use | to separate alternate matching options.

Regular expression John|Peter will match both John Smith and Peter Jackson.

Grouping

Use parenthesis ( and ) to specify subexpression.

Regular expression gr(a|e)y is the same as gray|grey and will match both gray and grey.

Repeating elements

? indicates there is zero or one of the preceding element. For example, colou?r matches both color and colour.

* indicates there is zero or more of the preceding element. For example, ab*c matches ac, abc, abbc, abbbc, and so on.

+ indicates there is one or more of the preceding element. For example, ab+c matches abc, abbc, abbbc, and so on, but not ac.

Case insensitive matching

Use (?i) to specify case insensitive matching.

For example, (?i)john will match John, JOHN, and john.

More information

Read more about available elements in Java regular expressions.