Input Formula Functions

You can specify string and arithmetic functions to be used to configure the values returned by the input formula.

To access the functions:

Click next to Input Formula.

Arithmetic Functions

Function, Syntax, and Description Arguments and Examples

`\$Add(<term1>,<term2>)`

Returns the sum of the two specified numbers.

`<term1>` - First term

`<term2>` - Second term

Example: `\$Add(2,3)` - Returns `5`
Subtract Numbers

`\$Sub(<term1>,<term2>)`

Returns the difference between the two specified numbers.

`<term1>` - First term

`<term2>` - Second term (amount to be subtracted)

Example: `\$Sub(3,2)` - Returns `1`
Multiply Numbers

`\$Mul(<term1>,<term2>)`

Returns the result of multiplying the two specified numbers.

`<term1>` - First term

`<term2>` - Second term (amount to multiply by)

Example: `\$Mul(3,2)` - Returns `6`
Divide Numbers

`\$Div(<term1>,<term2>)`

Returns the result of dividing a number by a second number.

`<term1>` - First term

`<term2>` - Second term (amount to divide by)

Example: `\$Div(6,2)` - Returns `3`

String Functions

Function, Syntax, and Description Arguments and Examples
Left Substring

`\$Left(<string>,<number>)`

Returns the leftmost specified number of characters from a specified string.

`<string>` - The character string

`<number>` - The number of characters to be returned

Example: `\$Left(ProjectAA,7)` - Returns `"Project"`
Right Substring

`\$Right(<string>,<number>)`

Returns the rightmost specified number of characters from a specified string.

`<string>` - The character string

`<number>` - The number of characters to be returned

Example: `\$Right(ProjectAA,2)` - Returns `"AA"`
Middle Substring

`\$Mid(<string>,<startpos>,<number>)`

Returns a substring from a specified string (starting at a specified position).

`<string>` - The character string

`<startpos>` - The number of the starting position. The first character is position 0.

`<number>` - The number of characters to be returned

Example: `\$Mid(ProjectAA,2,2)` - Returns `"oj"`
String X from List

`\$Token(<string>|<string>|...,<index>,|)`

Returns the element number X from an ordered list where the elements are delimited with a certain character.

This feature is useful in combination with controls connected to alias lists.

`<string>` - List of strings to choose from.

`<index>` - Index of string to use. This could be a variable linked to an alias list.

`|` - The character used to separate the <string> values.

Example:

`\$Token(Metal|Plastic|Metal,`

`,|)`

Where the Material variable is connected to an alias list with the following values:
Displayed Value Alias
Steel 1
Polyester 2
Gold 3
The formula string becomes Metal if the user selects Steel or Gold as the material. It becomes Plastic if the user selects Polyester.
String Length

`\$Len(<string>)`

Returns the length of a specified string.

`<string>`
Example: `\$Len(ProjectAA)` - Returns `9`
Find Substring

`\$Find(<string>,<substring>)`

Searches a specified string for the first match of a character or substring. Returns the position where the character or substring is found.

The first position in the character string is 0.
`<string>` - The character string

`<substring>` - The character substring for which to search

Example: `\$Find(abc,b)` - Returns `1`
Reversed Find Substring

`\$Reverse(<string>)`

Returns the reverse of a specified string.

`<string>` - The character string
Example: `\$Reverse(stockholm)` - Returns `"mlohkcots"`
Reverse Find

`\$FindReverse(<string>,<substring>)`

Searches a specified string for the last match of a character. Returns the position where the last occurrence of the character or substring is found.

The first position in the character string is 0.
`<string>` - The character string

`<substring>` - The character substring for which to search

Example: `\$FindReverse(abcabc,b)` - Returns `4`
Today's Date

`\$Time()`

Returns the current date in the format selected when the vault was created.

Example: `=\$Time()` - Returns `488a=2010-08-13`