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"} |
DriveWorks Tech Tips Portal |
Table Filtering The TableFilter function allows a Data Table to be filtered using other form controls (such as a text box or combo box) so that only the relevant items are displayed. |
DriveWorks Tech Tips Portal is available to DriveWorks Pro customers with an active subscription and support contract. Tech Tips provide cut down projects that highlight specific functionality for faster and more effective learning. To access the portal:
The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require. |