Here’s an all-in-one-place listing of FileMaker’s various functions, organized by type. Before digging into these tables, be sure you understand formulas and how to use expressions, constants, and operators. If you don’t, these tables won’t make much sense. For more information, see Defining Fields on page 99.
Table . Text Functions
Exact (original text, comparison text)
Returns a comparison of original text and comparison text in two text strings
Exact (original container, comparison container)
Returns a comparison of original container and comparison container in two container fields
Left (text, number)
Returns the specified number of characters in the supplied text, counting from the left
LeftWords (text, number ...