Find Row and Find Row Extended are located on the Data Tables menu. These functions search through a data table, comparing the input value with the values in the data table.
Find Row:
If a matching value is found, the number of the row is stored in the output value.
Find Row Extended:
This function enables you to search for more than one value. The number of the row containing all of the values is stored in the output value.
|
Parameter Name |
Purpose |
|
Table |
Click on the drop-down arrow to select a table from the project, then click the desired column. The number of bytes in the column of the linked data table define the length of the input vector. |
|
Limit Rows |
Check this option to limit the number of rows the function will search. |
|
Start Address |
The length of the input vector is determined by the number of bytes in the selected data table column. If, for example, the column contains 6 bytes, the vector will be 3 MIs long. Note that a string must end with a null (0) character. |
|
Found Row |
If a matching value is found, the number of the row is stored in the output value. Note that: - if the value is not found, -1 will be the value returned by the function. - if the row is not found, if, for example, the number given for the first row is higher than the number given for the last row, the value will be -2.
|