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