DriveWorks Pro 15: SppSearchTable [send feedback...]

SppSearchTable

Returns a table with matching search items in the given column.

Syntax

SppSearchTable([Table Array],[Column],[Search Text],[IncludeHeader])

Where:

Table Array is a Table array (such as the data in a standard table, or the result of a QueryDataValues function).

Column is the column on which to search for results. Number starting at 1 for the first column, 0 to search all columns.

Search Text is the text to look for in the specified column.

IncludeHeader is TRUE to include header values.

Examples

RuleMeaning
ListAll(SppSearchTable(DwTableName,2,"Tiger",TRUE),3)Will list all data from the third column of the array returned by the SearchTable function where items in the second column match the string "Tiger".

Table of Contents