MiddleWords
Purpose
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
Examples
MiddleWords("Plaid, Canvas, Suitcase";2;2) returns Canvas, Suitcase.
MiddleWords(Name;1;2) returns Brigitte Erika, when the Name field contains Brigitte Erika Durand.
Related topics