Home Search

DriveWorks Pro 21
SppTableSearch

Send Feedback

SppTableSearch

Searches all cells within a Table for a match to the specified Search Text returning the matching results as an Array.

Syntax

SppTableSearch([Table Array],[Search Text])

Where:

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

Search Text is the string of Text to search for in the given Table Array.

Example

RuleResultMeaning
SppTableSearch(DwLookupStationaryOrder,"HB Pencil"){"Items","Price","Quantity";"HB Pencil","0.60","3";"HB Pencil","0.60","2"}This will search the Table Array and return any items that match the Search Text as an Array.

Example Data

ItemPriceQuantity
HB Pencil0.603
2B Pencil0.602
Black Biro0.801
Rubber1.501
HB Pencil0.602
Black Biro0.801