With standardized domains you have the possibility to clean up your data in all business processes. In some cases, however, it may be necessary to transform the data before standardizing with domain values.
Transformation rules allow you to process the data before validating it.
The currently available Transformations Types are:
Lowercase
Transforms the input value to lowercase characters.
Uppercase
Transforms the input value to uppercase characters.
Trim
Returns a new string in which all leading, trailing of both occurrences of a set of specified characters are removed from a given input value.
Capitalize Each Word
Converts an input value to title case.
Add Prefix
Adds a specified character as a prefix to an input value, filling up to a given length.
Add Suffix
Adds a specified character as a suffix to an input value, filling up to a given length.
First N Characters
Returns up to the first N characters of an input value.
Last N Characters
Returns up to the last N characters of an input value.
Text Before Delimiter
Returns a substring of characters before the occurrence of the specified delimiter from an input value.
Text After Delimiter
Returns a substring of characters after the occurrence of the specified delimiter from an input value.
Text Between Delimiter
Returns a substring of characters between the first two occurrences of a specified delimiter.
Replace Text
Returns a new string in which all occurrences of a specified string are replaced with another specified string.