Reference > Functions reference > Text functions > MiddleWords
 

MiddleWords

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

Description 

If startingWord ≤ 1, then this function is evaluated as if startingWord = 1. If startingWord is greater than the number of words in text, this function returns nothing.

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