DriveWorks Pro 22

SppGetTableRowsBetweenText

SppGetTableRowsBetweenText

Returns an Array containing a specified number of data rows from an existing table based on a start and an end text.

Syntax

SppGetTableRowsBetweenText ([Table Array],[Column Number],[Start Text],[End Text],[Include Search Text In Results])

Where:

Table Array is a Table Array (such as the data in a standard table, or the result of a QueryDataValues function).

Column Number is the column number in which to find the start and end text.

Start Text is the text to search for to find the start row.

End Text is the text to search for to find the end row.

Include Search Text In Results is TRUE to include the rows containing the start and end text, FALSE to only include the rows between.

Example

Example Data

Returned Array In Table Format