O'Reilly logo

FileMaker Pro 6 for Windows and MacIntosh: Visual QuickStart Guide by Nolan Hester

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required