Find Row

Find the row of a data table.

Find the row or list of rows in which an input value is found from the data table and store it in a variable.

Input

• Input : DataTable Variable The DataTable in which the input value is to be searched for finding a row or list of rows.

Options

• Value : String Argument The input value is to be searched from the data table for finding a row or list of rows.

• Method :

  The method to find row

  • First - Get the first occurrence of value. It will return the first row that contains the input value.

  • AtIndex - Get the value in the specified index if there are multiple search results. It will return a row of a specified index if the input value is found in more than one row.

  • All - Get all values. It returns a list of rows in which the input value is found.

• Index : Integer Argument The index of the particular row from a list of rows in which the input value is found.

• Column Name : DynamicSearchString The name of the column in which the input value is to be searched.

  • Text - The full name of the column to be sorted.

  • Regex - The regex is used to find matching column names to be sorted.

  • Wildcard - The character that is used for search matching column name. The asterisk (*)and the question mark (?) are used as wildcard characters. The asterisk represents zero or more characters in a string. The question mark represents any one character.

The Text, Regex and Wildcard search methods are supported.EditDistance is not supported.

• Column Index : Integer Argument

  The index of the column in which the input value is to be searched. If this property is set then the Column Name property is ignored.

Output

• Output : Object Variable The variable that stores the resulting data table that contains the data row or a collection of data rows of the specified input value found in the data table.
• Found : boolean Variabl

  The variable that stores the row number or number of rows of specified input value found in the data table.