Home Search

DriveWorks Pro 21
SppTableRowIndexOfValue

Send Feedback

SppTableRowIndexOfValue

This function searches a table for the specified text in a column and returns the row index of its first occurrence.

This can be useful for finding the position of unique values within your table.

Syntax

SppTableRowIndexOfValue([Table Array],[Column],[Search Text],[Ignore Case])

Where:

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

Column is the column index on which to search.

Search Text is the text to find, must match exactly.

Ignore Case is True to perform a case sensitive search.

Example

RuleResultMeaning
SppTableRowIndexOfValue(DwLookupOfficeSupplies,1,"2B Pencil",TRUE)2Will search in the first column of the table Office Supplies, for the text 2B Pencil and return the Row Index 2.

Example Data

ItemPriceQuantity
HB Pencil0.603
2B Pencil0.602
Black Biro0.801
Rubber1.501
HB Pencil0.602
Black Biro0.801