Convert text

Converts all characters in the source column one row at a time, based on the specified transformation rule. The transformation rule includes all rows in the selected source column.

The following parameters are available.

Parameter

Description

Column

Name of the column whose values are converted.

Source: Source table

Data type: Text

Specification: Mandatory

Conversion

Transformation rule for conversion of column values:

UPPER: Converts all characters into upper case, according to the rules of the specified language.

LOWER: Converts all characters into lower case, according to the rules of the specified language.

ONLY_LETTERS: Removes all figures (0-9) from the column values;

ONLY_NUMBERS: Removes all letters from the column values.

REMOVE_SPACES: Removes all spaces from the column values.

REMOVE_LEADING_WHITESPACE: Removes leading whitespace from the column values.

REMOVE_TRAILING_WHITESPACE: Removes trailing whitespace from the column values.

Specification: Mandatory

Target column

Name of the column to which the conversation 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: Text

Default value: Result_1

Specification: Optional

If the target column is identical to the source column, the values in the source column are overwritten.