Support center for flex.bi version 3.2
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.