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 |