)

---

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.