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.
Result
The program robot completed successfully.
A vocabulary with two entries is formed.
Обзор
Инструменты контента