2.0

Functions
9-18 Using Calculations
Length
The Length function returns the number of characters in a given string.
The calculation counts all characters in a string including spaces.
Usage Example
Length([str1])
If the field [str1] = John Doe
Then the calculation Length([str1]) returns 8
In the example below, the length of the name in the
Name
field is put in
the
Length of Name
field.
Ln (Natural Logarithm)
The Ln function returns the natural logarithm (base e) of a number or
numeric expression. The number or numeric expression must be greater
than 0. Ln is the inverse of the Exp function.
Usage Example
Ln([num1])
If the field [num1] = 2
Then the calculation Ln([num1]) returns 0.69314718 (approximately)
In the example below, the natural logarithm is calculated using the
Ln
Value
field and put in the
Log
field.