Assigning values by using arithmetic operations


You can use arithmetic operations, such as "+ " or "- " to compute a value that you can use in a Set Fields action. The same arithmetic operations allowed for specifying qualifications are used to build a computed value (see Operators). The operation must meet all of the rules for arithmetic operations and produce a result with a type that is compatible with the target field.

If you include a process result or DDE result (active links only) in a mathematical operation, the process definition must not be contained within parentheses and it must be the last item in the operation because all data after the tag $PROCESS$ or $DDE$ is considered to be part of the command line or DDE definition.

In some cases, arithmetic operators can also be used for concatenation. Some examples of valid arithmetic operators are:

$TIMESTAMP$ - $CREATE-DATE$
$FIRST NAME$ + " " + $LAST NAME$
"hostname = " + $PROCESS$ hostname

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*