Creates an extract from each value in a text column starting from the specified position (start index), and with the specified length, and writes the result to a target column.
Searches the source column at the specified start index, using the specified length for the string,and displays it in the target column. Start index and length must be >= 0, otherwise an empty entry appears in the target column.
The following parameters are available.
Parameter |
Description |
---|---|
Column |
Name of the column whose values are searched. Source: Source table Data type: Text Specification: Mandatory |
Start index |
Start position of the string to be extracted. Source: Source column, single-value operator, input value, or constant. Size >= 0; Data type: Number Specification: Mandatory |
Length |
Number of characters in the string to be extracted. Source: Source column, single-value operator, user input, or constant. Number of characters >= 0 Data type: Number 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 |