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
AddCharLeft(Char,S,Count)
AddCharLeft returns a string left-padded to Length with characters Char
AddCharRight(Char,S,Count)
AddCharRight returns a string right-padded to Length with characters Char
RightString(S,Count)
RightString returns the trailing characters of String up to a length of Count characters
Replace(S,OldPattern,NewPattern)
Replace replaces all occurrences of the OldPattern by NewPattern within the String
SubString(S,Index,Count)
SubString returns a substring containing Count Characters or elements starting from Index.
LeftString(S,Count)
LeftString returns the leading characters of String up to a length of Count characters
MakeString(Char,Count)
MakeString returns a string of Count filled with character Char.
DelSpaces(S)
DelSpaces returns string with all spaces deleted except one.
"two spaces"->"two spaces
Delete(S,Index,Count)
Delete removes a substring of Count characters from string S starting with S[Index]. S is a string-type variable. Index and Count are integer-type expressions. If the index is larger than the length of the string or less than 1, no characters are deleted. If count specifies more characters than remain starting at the index, Delete removes the rest of the string. If count is less than or equal to 0, no characters are deleted
Insert(Substr,Dest,Index)
Insert merges Source into S at the position S[index]. The source is a string-type expression. S is a string-type variable of any length. An index is an integer-type expression. It is a character index and not a byte index. If Index is less than 1, it is mapped to a 1. If it is past the end of the string, it is set to the length of the string, turning the operation into an append. If the Source parameter is an empty string, Insert does nothing
ProperCase(S)
ProperCase returns a string, with the first letter of each word in uppercase and all other letters in lowercase "proper case"->"Proper Case"
UpperCase(S)
UpperCase returns a string with the same text as the string passed in S, but with all letters converted to lowercase. The conversion affects only 7-bit ASCII characters between 'A' and 'Z'. To convert 8-bit international characters, use AnsiUpperCase.
LowerCase(S)
LowerCase returns a string with the same text as the string passed in S, but with all letters converted to lowercase. The conversion affects only 7-bit ASCII characters between 'A' and 'Z'. To convert 8-bit international characters, use AnsiLowerCase.
AnsiUpperCase(S)
AnsiUpperCase returns a string that is a copy of S, converted to upper case.
AnsiLowerCase(S)
AnsiLowerCase returns a string that is a copy of the given string converted to lower case.
AnsiCompareStr(S1,S2)
AnsiCompareStr compares S1 to S2, with case sensitivity.
The return value is:
Condition Return Value
S1 > S2 > 0
S1 < S2 < 0
S1 = S2 = 0
AnsiCompareText(S1,S2)
AnsiCompareText compares S1 to S2, without case sensitivity. AnsiCompareText returns a value less than 0 if S1 < S2, a value greater than 0 if S1 > S2, and returns 0 if S1 = S2.
AnsiStrLIComp (S1,S2,MaxLen)
AnsiStrLIComp compares S1 to S2, without case sensitivity. If S1 or S2 is longer than MaxLen characters, AnsiStrLIComp only compares up to the first MaxLen characters.
The return value is:
Condition Return Value
S1 > S2 > 0
S1 < S2 < 0
S1 = S2 (up to MaxLen characters) = 0
AnsiLastChar(S)
Call AnsiLastChar to obtain the last character in a string.
Trim(S)
Trim removes leading and trailing spaces and control characters from the given string S.
TrimLeft(S)
TrimLeft returns a copy of the string S with leading spaces and control characters removed.
TrimRight(S)
TrimRight returns a copy of the string S with trailing spaces and control characters removed.
QuotedStr(S)
Use QuotedStr to convert the string S to a quoted string. A single quote character (') is inserted at the beginning and end of S, and each single quote character in the string is repeated.
AnsiQuotedStr(S,Quote)
Use AnsiQuotedStr to convert a string (S) to a quoted string, using the provided Quote character. A Quote character is inserted at the beginning and end of S, and each Quote character in the string is doubled.
AnsiExtractQuotedStr(S,Quote)
AnsiExtractQuotedStr removes the quote characters from the beginning and end of a quoted string and reduces pairs of quote characters within the string to a single quote character. The Quote parameter defines what character to use as a quote character. If the first character in S is not the value of the Quote parameter, AnsiExtractQuotedStr returns an empty string.
Copy(S,Index,Count)
S is an expression of a string or dynamic-array type. Index and Count are integer-type expressions. Copy returns a substring or sub-array containing Count characters or elements starting at S[Index]. The substring or sub-array is a unique copy (that is, it does not share memory with S, although if the elements of the array are pointers or objects, these are not copied as well.) If Index is larger than the length of S, Copy returns an empty string or array. If Count specifies more characters or array elements than are available, only the characters or elements from S[Index] to the end of S are returned.
MD5(S)
Call MD5 to get MD5 checksum for a string.
