ETL and Data Integration tools - Modern ETL software for everyone

HomeTransformation Functions

Transformation Functions

String Transformation

Below is list of String Transformations supported by Advanced ETL Processor

Image	Data Validation Function	Description
	Upper Case	Converts all characters of a string to Upper Case My String => MYSTRING
	Lower Case	Converts all characters of a string to Lower Case My String => my string
	Proper Case	Converts first character of all words within a string to Upper Case and the rest to the lower case my strinG => My String
	First Up	Converts first character a string to Upper Case and the rest to the lower case my strinG => My string
	Delete Spaces	Makes sure that there is only one space between words My string => My string
	Trim	Removes Leading and Trailing Spaces from a string
	Left Trim	Removes Leading Spaces from a string
	Right Trim	Removes Trailing Spaces from a string
	Sub String	Returns part of a string.
	Replace	Replaces a one or more characters from the data with zero or more new characters.
	Ensure Prefix	Check string for prefix and if it is missing adds it
	Ensure Suffix	Check string for suffix and if it is missing adds it
	Ensure No Prefix	Check string for prefix and if it is present removes it
	Ensure No Suffix	Check string for suffix and if it is present removes it
	Left Pad	Returns the string left-padded to the length with spaces or specified character.
	Right Pad	Returns the string right-padded to the length with spaces or specified character.
	Escape String	Replaces special characters such as TAB, CR, LF,NULL,BEL,BS,ESC,HT,FF,VT with there C-Style escape equivalents.
	UnEscape String	Opposite to Escape String, Replaces C-Style escape characters with special characters such as TAB, CR, LF,NULL,BEL,BS,ESC,HT,FF,VT.
	Delete	Deletes part of a string.
	Left	Returns left part of a string.
	Right	Returns right part of a string
	Left Delete	Deletes left part of a string
	Right Delete	Deletes right part of a string

Number Transformations

Below is list of Number Transformations supported by Advanced ETL Processor

Image	Data Validation Function	Description
	Round	Rounding is the process of reducing the number of significant digits in a number. The result of rounding is a "shorter" number having fewer non-zero digits yet similar in magnitude. The result is less precise but easier to use.For example: 73 rounded to the nearest ten is 70, because 73 is closer to 70 than to 80.
	Abs	Returns absolute value of a number. Absolute value is always positive. For example -2 will give 2
	Sign	Returns Sign of numeric value -1 for negative values, 1 for positive values and 0 for 0