Appendix : Operators : Data transformation operators : Convert text : Parameters
Parameters
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.
Copyright © 2013-2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback