Finds the specified search text in a search column and writes the position of the text found to a numerical target column.
If the search text is not found, the position is -1.
The following parameters operators are available.
Parameter |
Description |
---|---|
Column |
Name of the column whose values are searched. Source: Source table Data type: Text Specification: Mandatory |
Search text |
String for which the search is performed. Source: Column values from source table, single value from a feed (single-value operator), input value, or a constant. Data type: Text Specification: Mandatory |
Target column |
Name of the column to which the search result is written. This can be either a new column (typing a column name in the text field) or existing column (selecting a column from the drop-down menu). Data type: Number Default value: Result_1 Specification: Mandatory |
First/last hit |
If multiple results are found, the first or last hit is taken as the search result. |