Filemaker Pro 8.5 Educational Maintenance T1 TJ086LL/A 用户手册
产品代码
TJ086LL/A
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
start - any numeric expression or field containing a number
numberOfCharacters - 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
startingValue - any numeric expression or field containing a number
numberOfValues - any numeric expression or field containing a number
numberOfValues - any numeric expression or field containing a number