formulastrings(
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

- formulafields( -- returns a list of fields used in a formula.
- formulaidentfiers( -- returns a list of identifiers (fields and variables) used in a formula.
- formulavalue( -- calculates the result of a formula based on data in the current record of any open database. This is similar to the fieldvalue( function, but allows any formula to be used, rather than just a single field.
- formulavariables( -- returns a list of variables used in a formula.

History

Version | Status | Notes
10.2 | New | New in this version.