Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Lower(“ABCD”) returns 

.

Lower(Course) returns 

, when the Course field contains History.

Lower(“YOUR BILL IS OVERDUE”) returns 

.

Middle(text;start;numberOfCharacters)

text - any 

start - any numeric expression or field containing a number
numberOfCharacters - any numeric expression or field containing a number

text

Extracts the numberOfCharacters from text, starting at the character position 

specified by start.

Middle(“(408)555-9054”;2;3) returns 

.

Middle(PhoneNumber;2;3) returns 

 when the PhoneNumber field contains (408) 

555-9054.

Middle(“abcdefghij”;5;2) returns 

.

Middle(Name;Position(Name;“ “;1;1)+1;3) returns 

, when the text field 

Name contains John Smith.

MiddleValues(text;startingValue;numberOfValues)

text - any 

startingValue - any numeric expression or field containing a number
numberOfValues - any numeric expression or field containing a number