DriveWorks Solo 17: TableFilter [send feedback...]


Eliminates non-matching values from the table.


TableFilter(Table or Table Name As Table, Column Index 1 As Double, Condition 1 As String, Column Index 2 As Double, Condition 2 As String, Column Index 3 As Double, Condition 3 As String)


Table or Table Name is the Table to filter.

Column Index 1 is the first column to filter on.

Condition 1 is the condition to filter column 1 on.

Column Index 2 (optional) is the second column to filter on.

Condition 2 (optional) is the condition to filter column 2 on.

Column Index 3 (optional) is the third column to filter on.

Condition 3 (optional) is the condition to filter column 3 on.


TableFilter(DWLookupCustomers,1,"D*")Will filter the table Customers to return an array containing only the rows whose value in column 1 begins with D.

Example Data

Customers Table

Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States
Everso LuckyVermontUnited States
Forty SomethingsIllinoisUnited States

Example Outcome

Dynamo DynamicsIndianaUnited States

DriveWorks will return the table above as an array, which will look like:

Table returned as an Array
{"CustomerName","City","Country";"Dynamo Dynamics","Indiana","United States"}

Table of Contents