Returns a Table Array with matching search items in the given column.
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.
| Rule | Result | Meaning |
|---|---|---|
| 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. |
| FirstName | SecondName | Country | City |
|---|---|---|---|
| Frank | Johnson | USA | Charlotte |
| Jack | Jones | United Kingdom | Swansea |
| Laura | Hughes | United Kingdom | Leeds |
| Tent | Davids | Canada | Toronto |