Functions Reference

176 FileMaker Functions Reference
Examples
Lower(“ABCD”) returns abcd.
Lower(Course) returns history, when the Course field contains History.
Lower(“YOUR BILL IS OVERDUE”) returns your bill is overdue.
Middle
Format
Middle(text;start;numberOfCharacters)
Parameters
text - any text expression or text field
start - any numeric expression or field containing a number
numberOfCharacters - any numeric expression or field containing a number
Data type returned
text
Description
Extracts the numberOfCharacters from text, starting at the character position
specified by start.
Examples
Middle(“[phone]”;2;3) returns 408.
Middle(PhoneNumber;2;3) returns 408 when the PhoneNumber field contains (408)
555-9054.
Middle(“abcdefghij”;5;2) returns ef.
Middle(Name;Position(Name;“ “;1;1)+1;3) returns Smi, when the text field
Name contains John Smith.
MiddleValues
Format
MiddleValues(text;startingValue;numberOfValues)
Parameters
text - any text expression or text field
startingValue - any numeric expression or field containing a number
numberOfValues - any numeric expression or field containing a number