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.