Home
FilterByText
This function filters (removes) the rows that have a matching text pattern in the row label or a text column specified.

Syntax:

FilterByText, caption, operator, tildeDelimitedStrings

Parameters:

caption - the row label or text column caption to use 

operator – the test operator to use { ExactMatch, Contains, StartsWith, EndsWith }

tildeDelimitedStrings – a tilde-separated list of strings to test for 

Examples:

FilterByText,Year,Contains,2006~2007

Removes the rows with a row label ('Year') that contains the text ‘2006’ or ‘2007’.

Change History:

v3.1 - new command

 

 
< Prev   Next >

Reference