Transformation

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.