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
Iif(expr1=expr2;expr3;expr4)
Iif function returns expr3 or expr4 depending on expr1=expr2
GetSystemVariable(VariableName)
GetSystemVariable returns value of 'VARIABLENAME'.
Possible values for 'VARIABLENAME' are:
COMPUTERNAME
OSUSERNAME
DBUSERNAME
BLOCKNUMBER
LINENUMBER
RECORDNUMBER
SYSTEM_DATE
SOURCE_FILE_NAME
SOURCE_TABLE_NAME
GetSystemDate(Format)
Returns Current system date/time in the format specified
GetSystemDate('MMDDYYYY')
Pos(Substr,S)
Pos searches for Substr within String and returns an integer value that is the index of the first character of Substr within String. Pos is case-sensitive. If Substr is not found, Pos returns zero.
AnsiPos(Substr,S)
Call AnsiPos to obtain the byte offset of the Substr parameter, as it appears in the string S. For example, if Substr is the string "AB", and S is the string "ABCDE", AnsiPos returns 1. If Substr does not appear in S, AnsiPos returns 0.
Chr(X)
Returns the character for a specified ASCII value.
Length(X)
Returns the number of characters in a string or elements in an array.
Pos(Substr,Str)
Pos searches for Substr within S and returns an integer value that is the index of the first character of Substr within S. Pos is case-sensitive. If Substr is not found, Pos returns zero
SetLength(S,Length)
Set Length of dynamic array or string
High(X)
Call High to obtain the upper limit of an Array
Low(X)
Call Low to obtain the lowest value or first element of an Array.
