Breaks the table into two at, or after the row matching the given condition, and returns either the top or bottom half.
TableBreak([Table or Table Name], [Column Index], [Condition], [Top], [Include Break Row], [Ignore Whitespace])
Where:
Table or Table Name is the Table to break.
Column Index is the number of the column in which to check for a match.
Condition is the condition that defines the break.
Top will return the top portion of the break, when TRUE. Otherwise it will return the bottom portion when FALSE.
Include Break Row will include the row from which the break starts, when TRUE.
Ignore Whitespace (optional) is True to ignore leading/trailing whitespace characters in text strings, in the condition, otherwise False.
| Rule | Meaning |
|---|---|
| TableBreak(DwLookupCustomers,1," C*",TRUE,TRUE,TRUE) | Will return an array of the rows from the Table Customers up to the entry beginning C, and will include the row at which the break occurs. Will remove the whitespace, after the first ". |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indiana | United States |
| Eagle Sizzlers | Maine | United States |
| Everso Lucky | Vermont | United States |
| Forty Somethings | Illinois | United States |
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","City","Country";"Amazon Warriors","Paris","France";"Bolton Burners","Concord","United States";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France"} |