Reference > Functions reference > Text functions > MiddleWords
 
MiddleWords
Purpose 
Returns text containing the specified numberOfWords from specified text, starting at startingWord.
Format 
MiddleWords(text;startingWord;numberOfWords)
Parameters 
text - any text expression or text field
startingWord - any numeric expression or field containing a number
numberOfWords - any numeric expression or field containing a number
Data type returned 
text
Originated in 
FileMaker Pro 6.0 or earlier
Examples 
MiddleWords("Plaid, Canvas, Suitcase";2;2) returns Canvas, Suitcase.
MiddleWords(Name;1;2) returns Brigitte Erika, when the Name field contains Brigitte Erika Durand.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
WordCount function