Home Search

DriveWorks Pro 21
SppGetTableRowsBetweenText

Send Feedback

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

RuleResultMeaning
SppGetTableRowsBetweenText(DwLookupCustomers,5,"France","Canada",TRUE){"FirstName","SecondName","Company","City","Country"; "Juliette","Dubois","Marquardt-Pouros","Lyon","France"; "Isabella","Wem","Bayer-Welch","Velbert","Germany"; "Martin","Biddiss","Howell West Ltd","London","United Kingdom";"Freddie","Milleton","Hill Ltd","Toronto","Canada"}Will return all rows between the search text fields.

Example Data

FirstNameSecondNameCompanyCityCountry
JeffBeachStromann Roofing LLCColumbusUSA
ThomasJacksonKing LLCSan FranciscoUSA
SamJonesCork & SonsCardiffUnited Kingdom
JulietteDoboisMarquardt PourosLyonFrance
IsabellaWemBayer WelchVelbertGermany
MartinBiddissHowell West LtdLondonUnited Kingdom
FreddieMilletonHill LtdTorontoCanada
PatrickDishmanHarber and DietrichCharlotteUSA
IvettOaksCartman GroupDumfriesUnited Kingdom
TobeHellyarSchneider ManzBerlinGermany

Returned Array In Table Format

FirstNameSecondNameCompanyCityCountry
JulietteDoboisMarquardt PourosLyonFrance
IsabellaWemBayer WelchVelbertGermany
MartinBiddissHowell West LtdLondonUnited Kingdom
FreddieMilletonHill LtdTorontoCanada