Search

Search Data in Table

Articles

Use this function to find row number of input data in the input table.

Syntax

Search data in Table (table, start_column_no, search_string)

Parameters

Input Parameter Name Description
table Data Table Variable
start_column_no Column Number to start search from
search_string Data to be searched in the table

Returns

Return value Description
Row_number Returns the row in which data is present

Sample

Search data in Table (InventoryTable,1, ZMR26XET9UJ)

  • Finds the row number in which ZMR26XET9UJ is present in table InventoryTable and start the search from first column.
    Returns row number as 2.

To view all the Table functions, click here.

Did you find what you were looking for?