Reference > Functions reference > Text functions > MiddleWords


Returns text containing the specified numberOfWords from specified text, starting at startingWord.




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 


Originated in 

FileMaker Pro 6.0 or earlier

Example 1 

MiddleWords("Plaid, Canvas, Suitcase";2;2) returns Canvas, Suitcase.

Example 2 

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