Searches all cells within the given table for a match to the specified search text and returns the entire rows as an array.
TableSearch([Table or Table Name], [Search Text], [Ignore Case])
Where:
Table or Table Name is the Table to search.
Search Text is the criteria to search for
Ignore Case (optional) is False to perform a case sensitive search, True for insensitive.
| Rule | Meaning |
|---|---|
| TableSearch(DWLookupCustomers,"Concord",FALSE) | Will search the table Customers to return an array containing only the rows that contain the search text "Concord". |
| TableSearch(DWLookupCustomers,"C*") | Will search the table Customers to return an array containing only the rows that contain the search text "C*"(Returns everything that starts with a C). |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indianapolis | United States |
| Eagle Sizzlers | Columbus | United States |
| Everso Lucky | Burlington | United States |
| Forty Somethings | Chicago | United States |
| CustomerName | City | Country |
|---|---|---|
| Bolton Burners | Concord | United States |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","City","Country";"Bolton Burners","Concord","United States"} |
| CustomerName | City | Country |
|---|---|---|
| Bolton Burners | Concord | United States |
| Cambridge Cats | Toulouse | France |
| Eagle Sizzlers | Columbus | United States |
| Forty Somethings | Chicago | United States |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","City","Country"; "Bolton Burners","Concord","United States"; "Cambridge Cats","Toulouse","France"; "Eagle Sizzlers","Columbus","United States"; "Forty Somethings","Chicago","United States"} |