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.
Note  Characters such as the ampersand (&) and hyphen (-) can be used to identify the beginning of a new word.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.