formulastrings(
FORMULA
)

The formulastrings( function returns a data array of strings (text constants) used in a formula.


Parameters

This function has one parameter:

formula – is the formula to be analyzed. If the formula is specified inline in the function itself, it must be quoted (see Quotes). Otherwise, you can pre-store the formula in a field or variable.


Description

The function returns a data array of strings (text constants) used in a formula.

For example,

formulastrings({?(Gender match "m*","Mr.","Ms.")})

will return a data array with the three text constants that appear in this formula:

M*
Mr.
Ms.

See Also


History

VersionStatusNotes
10.2NewNew in this version.