Functions Reference

FILEMAKER FUNCTIONS REFERENCE 229
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)
MiddleValues
Purpose
Returns a text result containing the specified numberOfValues in text, starting with
startingValue.
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
Important See Design functions for information about literal text parameters.
Data type returned
text
Originated in
FileMaker Pro 7.0
Description
Values are text items separated by carriage returns. A value can be empty, a single character, a
word, a sentence or a paragraph. When you press Return you start creating a new value. The last
value will be recognized with or without a carriage return.
Each value that is returned ends with a carriage return, allowing lists to be easily concatenated.
Examples
MiddleValues(“Plaid¶Canvas¶Suitcase”;2;1) returns
Canvas