MiddleWords

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

Format 

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

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