Skip to content

Operator Documentation

Martin Danielsson edited this page Jul 10, 2015 · 17 revisions

Operator Documentation

String Operators

Operator Description
Yeah Lots of em

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 Returns boolean false
Not Operator Negates a boolean return value
Or Operator Boolean "or" operator
True Operator Returns boolean `true'

Filter Operators

Operator Description
FilterDuplicate Operator Filters for duplicates of values.
FilterOnce Operator Filters for all unique values.

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.

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

Misc Operators

Operator Description
SourceRowNum Operator Returns the source row number.
TargetRowNum Operator Returns the target row number.
TimeSpanMonths Operator Calculates the number of months between two date strings.
Clone this wiki locally