Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Text functions > Right function |
|
|
| Right function |
| 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 |
| Description |
| Returns the specified numberOfCharacters in text, counting from the right. |
| 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 |
|
|
| Contents > Functions reference (alphabetical list) > Text functions > Right function |
|
|
Next Page |
|