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 version 

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