Extract text

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