Replace text

Replaces text in a search column with the specified Find or Replace text one row at a time, or writes the text to a target column.

If the search text cannot be found, the search text itself is written to 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

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

Replacement text

String that replaces the search text.

Source: Source table, single-value operator, input value, or constant.

Data type: Text

Specification: Optional

If no replacement text is specified, the search text found is replaced with a empty text.

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, last, or all hits is/are replaced.

The specification relates to occurrence within the individual rows of the search column and not to the sequence of rows, that is, NOT "First row", "Last row" and "All rows".