Using regular expressions

You can use JavaScript-style regular expressions in Free text filters

Regular ExpressionMatched Values
[Dd]oeDoe, doe
colo(u)?rcolor, colour
Developer|ScientistDeveloper, Scientist

Table Filter macro uses the OR operator for table filtration. You can use the AND operator in the free text and global filters. Enter the '&' ('ampersand') between values to match two or more values in the cell at once.

The full list of regular expressions is available here .

Free text filters allow you to use regular expressions while filtering table data. They allow you to write powerful filtration queries.

Quick Recipes with Regular Expressions

Regular ExpressionExplanationExample
\d\.\dThis query will look for two digits separated by the point (for example, '8.1', '9.5'). Entries with more than one digit after the point will be also included.

If applying the '\d\.\d' query to the Operating System column, you will get three values with 'OSx 5.7', 'cOS 7.2' and 'aOS 2.8' after filtration.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

UserOperating System
MikeOSx 5.7
JaneSuperOS
StewartOSx 9
Jane

cOS 7.2

AndyaOS 2.8
\d\d\:\d\d\:You can use this query if you want to filter dates having time and dates without time.

If applying the '\d\d\:\d\d\:' query to the Sync Time column, you will get three values with '11/17/2015 10:35:58', '11/17/2015 12:24:54' and '11/19/2015 16:47:22' after filtration.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

UserSync Time
Mike11/17/2015 10:35:58
Jane11/28/2015
Stewart11/17/2015 12:24:54
Jane11/30/2015
Molly11/16/2015 17:28
Andy11/19/2015 16:47:22

^[0-9]{2}$

^[0-9]{3}$

You can use these queries if you want to filter people by age depending on the number of digits.


If applying the '^[0-9]{2}$' query to the Age column, you will get three numbers comprised of two digits.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

UserAge
Mike120
Jane75
Stewart57
Jane111
Molly85

\b([1-1][1-1])

\b([1-1][2-2])

\b([1-1][3-3])

and so on

You can use this query if you have a list with timestamps and you would like to see how many operations were performed at a particular hour,

If applying the '\b([1-1][1-1])' query to the Login time column, you will get three entries of login attempts.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

UserLogin Time
Mike11:30:25
Jane13:31:25
Stewart11:32:25
Jane12:40:25
Molly11:47:25
Stewart12:20:25
^Administrator$

You can use this query if you want to filter exactly a specific value:

^  matches the beginning of the string

$ - matches the end of the string

If applying the '^Administrator$' query to the Roles column, you will get only one entry (the first row).

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

RolesFirst NameLast Name
Administrator PaulJohnting
Administrator ToolAlexanderJohns
Tool Administrator

John

Johnston
Application Consultant  MikeJohney
Solution ConsultantAliceJohnson
h(n|a)sYou can use this query if you want to filter last names having either 'n' or 'a' between h and s.

If applying the 'h(n|a)s' query to the Last Name column, you will get four entries (Johns, Johnston, Johnson and Johason).

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

First NameLast Name
AlexanderJohns

John

Johnston
MikeJohney
AliceJohnson

Pavel

Johason
JaneJohannesen
JannetJohndrow
PaulJohnting
Ruby & Python

You can use '&' (ampersand) to filter cells consisting two or more values standing in different positions in the cells.

This is a custom enhancement in the add-on that simplifies the usage of the regular expression to filter cells containing two or more values at a time.

If applying the 'Ruby & Python' query to the Skills column, you will get two names of employees who have these skills.

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

UserSkills
MikeJava, JavaScript, HTML5, CSS, ASP, Agile
JaneJava, PHP, CSS, HTML5, Agile, Ruby
StewartSOAP, JSON, PHP, CSS, Java, REST, C++
JaneJava, Ruby, Python, PHP, CSS, HTML5
MollyPHP, CSS, Java, JavaScript, HTML5
StewartRuby, HTML5, PHP, CSS, JavaScript, Python