U.M. (Mac OS)

Creating a database file 2-19
Use AND, OR, or XOR to combine two expressions; use NOT with only
one expression.
Text operators
Use the following text operators with text expressions. (Double quotation marks indicate a
text expression.)
Choose FileMaker Help Index from the or Help menu, and then type:
E logical operators
Symbol Name Definition Examples
& Concatenation Appends the text string on the
right to the end of the text string
on the left
"XXX" & "ZZZZZ" returns
"XXXZZZZZ"
" " Text constant Marks the beginning and the
end of a text constant. Quotation
marks without text between
them indicate a blank space. If
you enter text into a formula
without using quotation marks,
FileMaker Pro interprets the
text as a field name or function
name. To put a quotation mark
in a text constant, precede it
with another quotation mark.
"Sydney, NSW" returns
Sydney, NSW
"" returns an empty (null)
value
"The report said
""Confidential"" on
the top" returns The report
said "Confidential" on the top
¶ Return marker Inserts a paragraph return in a
text constant
"M.T.N.Trek¶Sporting¶
Equipment" returns
M.T.N. Trek
Sporting
Equipment
(The ¶ symbol must be
enclosed within the quotation
marks of the text constant)
Choose FileMaker Help Index from the or Help menu, and then type:
E text operators