Operator Documentation

String Operators

Operator	Description
Concat Operator	Concatenates two strings.
Contains Operator	Checks for existance of a substring in a string
ContainsIgnoreCase Operator	See above.
ConvertUmlaut Operator	Converts Umlauts as ä, ö, ü to ae, oe, ue.
EndsWith Operator	Checks whether a string ends with an other string
Equals Operator	Checks for string equality
EqualsIgnoreCase Operator	Checks for string equality, ignoring casing
Greater Operator	Returns true if first parameter is greater than second
GreaterEqual Operator	Returns true if first parameter is greater or equal to the second
IndexOf Operator	Returns the index of a substring.
IsEmpty Operator	Returns true if the input parameter is empty
Length Operator	Returns the length (as int) of the input string
Less Operator	Returns true if first parameter is less than second
LessEqual Operator	Returns true if first parameter is less or equal to the second
LowerCase Operator	Converts a string to all lower case
PadLeft Operator	Pads an input string to the left
PadRight Operator	Pads an input string to the right
Replace Operator	Replaces a string within an input string with another
StartsWith Operator	Returns true if the first parameter string starts with the second
Trim Operator	Trims the input string from blanks and white space
UpperCase Operator	Converts the input string to all UPPER CASE

Lookup Operators

Operator	Description
Lookup Operator	The lookup operator.
HasKey Operator	Returns true if the specified lookup contains the given key.

Arithmetic Operators

Operator	Description
Add Operator	Adds two integer expressions
Divide Operator	Divides two integer expressions
Equals Operator	Checks for equality
Greater Operator	Returns true if first parameter is greater than second
GreaterEqual Operator	Returns true if first parameter is greater or equal to the second
Int Operator	Tries to convert a string to an integer
Less Operator	Returns true if first parameter is less than second
LessEqual Operator	Returns true if first parameter is less or equal to the second
Modulo Operator	Divides first with second parameter and returns the remainder
Multiply Operator	Multiplies two integer expressions
Subtract Operator	Subtracts the second from the first integer expression

Boolean Operators

Operator	Description
And Operator	Boolean "and" operator
Equals Operator	Checks for equality
[[False Operator	Boolean-Operator]]
Not Operator	Negates a boolean return value
Or Operator	Boolean "or" operator
[[True Operator	Boolean-Operator]]

Filter Operators

Operator	Description
FilterDuplicate Operator	Filters for duplicates of values.
FilterOnce Operator	Filters for all unique values.
FilterLog Operator	Logs a filter fail to the transformation logger.
FilterLogLastMessage Operator	Outputs the last filter log message as a string.

File Operators

Operator	Description
FileContent Operator	Reads from a file and outputs a given number of characters into a string.
FileExt Operator	Returns the extension (suffix) of a file name.
FileResolve Operator	Tries to resolve file name to an absolute path.
FileSize Operator	Returns the file size of a file.
FileTempName Operator	Returns a random file name (without a path), per record and key
FileWriteText Operator	Writes a string into a file

Validation Operators

Operator	Description
IsValidEmail Operator	Checks for email address validity.
IsValidUri Operator	Checks for valid URIs (Salesforce).
RegExMatch Operator	Checks a value against a regular expression
RegExCapture Operator	Captures a value from a regular expression

Misc Operators

Operator	Description
Error Operator	Cancels the transformation process and throw a specific error message
If Operator	Evaluates first argument, returns second if true, otherwise third
Random Operator	Returns a random number between 0 and (not including) a given number
ReformatDate Operator	Reformats a date or date/time string from one format to another.
SourceRowNum Operator	Returns the source row number.
TargetRowNum Operator	Returns the target row number.
TimeSpanMonths Operator	Calculates the number of full months between two date strings.
TimeSpanDays Operator	Calculates the number of full days between two date strings.
TransformHasResult Operator	Returns true if a transformation returned results.