MashZone NextGen 10.2 | 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-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release