Home Search

DriveWorks Pro 21
SppSearchTable

Send Feedback

SppSearchTable

Returns a Table Array 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.

Example

RuleResultMeaning
SppSearchTable(DwLookupCustomers,3,"United Kingdom",TRUE){"First Name","Second Name","Country","City"; "Jack","Jones","United Kingdom","Swansea"; "Laura","Hughes","United Kingdom","Leeds"}This will return a Table Array containing rows where a matching result was found for the value that was searched for.

Example Data

FirstNameSecondNameCountryCity
FrankJohnsonUSACharlotte
JackJonesUnited KingdomSwansea
LauraHughesUnited KingdomLeeds
TentDavidsCanadaToronto