Functions Reference

FILEMAKER FUNCTIONS REFERENCE 212
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.
Related topics
Contents
Functions reference (alphabetical list)
Middle
Purpose
Extracts the numberOfCharacters from text, starting at the character position specified by
start.
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
Originated in
FileMaker Pro 6.0 or earlier
Examples
Middle(“[phone]”;2;3) returns 408.
Middle(PhoneNumber;2;3) returns 408 when the PhoneNumber field contains [phone].
Middle(“abcdefghij”;5;2) returns ef.
Middle(Name;Position(Name;“ ”;1;1)+1;3) returns Smi, when the text field Name
contains John Smith.
Related topics
Contents
Functions reference (alphabetical list)