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(“(408)555-9054”;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
Commentaires sur ces manuels