User manual

11-6 FileMaker Pro User’s Guide
Number functions
Length (text) Returns the number of characters in text.
Lower (text) Returns text as lowercase.
Middle (text, start, size) Returns characters in text, counting from the
position of start, through the number of
characters in size.
MiddleWords (text, starting
word, number of words)
Returns the middle words in text, beginning
with the number of the starting word and
continuing through the number of words to
the right.
PatternCount (text, search string) Returns the number of occurrences of search
string in text.
Position (text, search string,
start, occurrence)
Returns the position of the specified
occurrence of search string in text, from
start. Returns 0 if the string doesn’t appear
as specified. Position is not case sensitive.
Proper (text) Returns the first letter in each word of text as
uppercase and the remainder as lowercase.
Replace (text, start, size,
replacement text)
Replaces characters in text with replacement
text, from the position of start and
containing the number of characters in size.
Right (text, number) Returns the character(s) in text specified by
number, counting from the right.
RightWords (text, number of
words)
Returns the word(s) in text specified by
number of words, counting from the right.
Substitute (text, search string,
replace string)
In text, substitutes each occurrence of search
string with replace string. Substitute is case
sensitive.
TextToDate (text) Returns text as data of type Date. Type text
in the format MM/DD/YYYY.
TextToNum (text) Returns text as data of type Number.
TextToTime (text) Returns text as data of type Time. Type text
in the format HH:MM:SS, with or without
seconds and AM or PM.
Syntax Definition
Trim (text) Returns text without leading and trailing
spaces.
Upper (text) Returns text as uppercase.
WordCount (text) Returns the number of words in text.
Syntax Definition
Abs (number) Returns the absolute value of number.
Exp (number) Returns the value of e raised to the power of
number.
Int (number) Returns the integer (whole) portion of number.
Mod (number, divisor) Returns the remainder after number is divided by
divisor.
NumToText (number) Returns number as data of type Text.
Random Returns a random number between 0 and 1.
Round (number, precision) Returns number rounded to the number of
decimal places in precision. When precision is
negative, all digits right of the decimal separator
are dropped and number is rounded to the nearest
ten for a precision of -1, the nearest hundred for
-2, and so on.
Sign (number) Returns –1 when number is negative; returns 0
when number is zero; returns 1 when number is
positive.
Sqrt (number) Returns the square root of number.
Truncate (number,
precision)
Returns number truncated to the number of
decimal places in precision.
Syntax Definition