A powerful Data transformation language similar to Pascal is included in all our ETL and Business automation tools.
It can be used with Calculation Transformation Function, Package Script Action or inside any text object
IntToStr(S)
IntToStr converts an integer into a string containing the decimal representation of that number.
IntToHex(I,Digits)
IntToHex converts a number into a string containing the number's hexadecimal (base 16) representation. Value is the number to convert. Digits indicate the minimum number of hexadecimal digits to return.
StrToInt(S)
StrToInt converts the string S, which represents an integer-type number in either decimal or hexadecimal notation, into a number. If S does not represent a valid number, StrToInt raises an exception.
StrToIntDef(S,Default)
StrToIntDef converts the string S, which represents an integer-type number in either decimal or hexadecimal notation, into a number. If S does not represent a valid number, StrToIntDef returns Default.
FloatToStr(F)
FloatToStr converts the floating-point value given by Value to its string representation. The conversion uses a general number format with 15 significant digits.
StrToFloat(S)
Use StrToFloat to convert a string, S, to a floating-point value. S must consist of an optional sign (+ or -), a string of digits with an optional decimal point, and an optional mantissa. The mantissa consists of 'E' or 'e' followed by an optional sign (+ or -) and a whole number. Leading and trailing blanks are ignored.
IntegerToString(Integer)
IntegerToString converts integer value to a string value.
NumberToString(Float)
NumberToString converts float value to a string value.
StringToInteger(S)
StringToInteger converts string value to an integer value.
StringToNumber(S)
StringToNumber converts string value to a float value.
