U.M. (Windows)

C-2 FileMaker Pro User’s Guide
Some functions require two or more parameters, as in this example:
Position(LastName,"Mc",1, 1)
You can nest one function within another to perform more powerful
calculations on your data, as in this example:
Left(Name,Position(Name," ",1, 1))
The result of a function can be used as a constant. The following
example shows how FileMaker Pro evaluates a complex formula by
simplifying each function into a constant. In the example, the Right
function returns every character of text that is to the right of the first
space in the Name field. (This example shows how Right returns the last
name of a field that contains a first name and last name, when the value
doesn’t include a title like Dr. or middle initials.)
Keep these points in mind:
1 The following sections summarize FileMaker Pro functions. Values
in quotation marks ("") are text values. To include a space in a text
expression, type a quote, then a space, then a quote (" "). For
complete information about each function, including examples, see
FileMaker Pro Help.
1 A function can return the following data types: text, number, date,
time, or container. However, you determine the data type of the
calculated field when you define its calculation.
Choose FileMaker Help Index from the Help menu, and then type:
E functions, using
Contents of Name
Formula walk-through
Indicate a space in your
calculation by typing
quote, space, quote
?