Functions Reference

170 FileMaker Functions Reference
Data type returned
text
Description
Returns all letters in text as lowercase.
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.