Searches all cells within a Table for a match to the specified Search Text returning the matching results as an Array.
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.
| Rule | Result | Meaning |
|---|---|---|
| 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. |
| Item | Price | Quantity |
|---|---|---|
| HB Pencil | 0.60 | 3 |
| 2B Pencil | 0.60 | 2 |
| Black Biro | 0.80 | 1 |
| Rubber | 1.50 | 1 |
| HB Pencil | 0.60 | 2 |
| Black Biro | 0.80 | 1 |