Find text (Tables)

Find text Version 1 (Net)

Action group: Tables

Description

The action returns the address of the cell that contains the given text.

Action icon

Settings of parameters

Property	Description	Type	Filling example	Mandatory field
Parameters
Data table	Table for which the action will be performed.	Robin.DataTable		Yes
Start cell column	Column of the starting cell from which the search will be performed. By default, the bounds of the used area are applied from the context.	Robin.Numeric		No
Start cell row	Row of the starting cell from which the search will be performed. By default, the bounds of the used area are applied from the context.	Robin.Numeric		No
End cell column	Column of the destination cell to which the search will be performed. By default, the bounds of the used area are applied from the context.	Robin.Numeric		No
End cell row	Row of the destination cell to which the search will be performed. By default, the bounds of the used area are applied from the context.	Robin.Numeric		No
Text	The text to be searched for.	Robin.String		Yes
Search method	Search method. Full-text search will be applied by default.	Robin.String		No
Results
Result	Dictionary with elements - found cells: element key = cell address, element value = cell value.	Robin.Dictionary

Special conditions of use

None.

Example of use

Task

There is a CSV table. You need to find the text "Robin" and return a dictionary with items - found cells: item key = cell address, item value = cell value.

Solution

Use "Get table from CSV", "Find text" actions.

Implementation

Assemble a robot scheme with the actions:
Set the "Get table from CSV" action parameters.
Set parameters for the "Find text" action. In the variable "Text" you should specify the text to search for.
Click "Start" in the top panel.