Variables

A variable refers to a value which may be a number, string or object. Multiple variables can be contained within one expression or function.

RowSet Values

RowSet values can be accessed by placing the column name or column number inside of [ ] (square brackets). Column names must be placed inside double or single quotes. Additional functions, equations and other expressions can be placed in the square brackets.

Keywords

The following keywords are reserved for use by expressions and cannot be used as variable names in

Managed File Transfer

:

true
false
and
or
ne
eq
gt
lt
le
ge
not
null
if
else
elseif
break
continue
do
while
dowhile
for
foreach
try
catch

Method Calls

Method Calls are way to retrieve additional METADATA for a variable. To call a method, insert a colon and the method name immediately after the variable name. Each variable type (File List, Local File, Email List, etc) provides a different set of methods that are available. Refer to the Variables topic for a complete list of methods that are available for each variable type.

Grouping

Parentheses can be placed in expressions to determine the order of precedence.

Functions

A function is declared by placing parentheses after the function name. If parameters are needed, they should be placed inside the parentheses and must be separated by commas. Each parameter can contain additional functions, equations, strings, variables and any other expression value.

Strings

Any text that is enclosed in single or double quotes is treated as a string value.

Numbers

An expression may contain whole numbers, decimals or numbers written in scientific notation. Numbers can optionally be formatted with patterns by using the FormatNumber(number, pattern) function.

Math Operators

Valid math operators are:

+

Addition

-

Subtraction

*

Multiplication

/

Division - When dividing numbers that result in a decimal value, the maximum number of digits to the right of the decimal point is 16.

%

Returns the remainder after the first operand is divided by the second operand.

^

Raises the first operand to the power of the second operand.

Logical Operators

Multiple conditions can be separated with the logical operators AND (&&) and OR (||). The AND operator requires both sides to evaluate to true. If the first operand evaluates to false the second operand is not evaluated. The OR operator requires that either side evaluates to true. If the first operand evaluates to true the second operand is not evaluated.

Comparison Operators

Both string and symbolic operators are supported.

== or eq

Equals

<> or ne

Not Equal

< or lt

Less Than

>or gt

Greater Than

<= or le

Less Than or Equal to

>= or ge

Greater Than or Equal to