RightWords
Purpose 
Returns a text result containing the numberOfWords in text, counting from the right.
Format 
RightWords(text;numberOfWords)
Parameters 
text - any text expression or text field
numberOfWords - any numeric expression or field containing a number
Data type returned 
text
Originated in 
FileMaker Pro 6.0 or earlier
Examples 
RightWords(“Plaid Canvas Suitcase”;2) returns Canvas Suitcase.
RightWords(Name;1) returns Virtanen, when the Name field contains Matti Virtanen.
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