RightWords

Returns text containing the specified numberOfWords in text, counting from the right.

Format 

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

Example 1 

RightWords ( "Plaid Canvas Suitcase" ; 2 ) returns Canvas Suitcase.

Example 2 

RightWords ( Name ; 1 ) returns Virtanen, when the Name field contains Matti Virtanen.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

WordCount function