Appendix B. Functions
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
SYNTAX | DEFINITION |
|---|---|
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 ... |
Get FileMaker Pro 6 for Windows and MacIntosh: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
