Right
 
Purpose 
Returns the specified numberOfCharacters in text, counting from the right.
Format 
Right(text;numberOfCharacters)
Parameters 
text - any text expression or text field
numberOfCharacters - any numeric expression or field containing a number
Data type returned 
text
Originated in 
FileMaker Pro 6.0 or earlier
Examples 
Right(“Manufacturing”;4) returns ring.
Right(Name;Length(Name) - Position(Name;“ “;1;1)) returns Cannon, when the Name field contains Michelle Cannon.
Right(SerialNumber;3) & Upper(Left(LastName;4)) returns 187FERR when the SerialNumber text field contains 00-48-187 and LastName contains Ferrini.
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.