RIGHT function

RIGHT(text, length?) RIGHT(text; length?)


Text or { Text }

The string from which to extract a part.


Number or { Number } (optional)

The number of characters to include. If omitted, 1 is assumed, meaning that only the last character of the text string is returned.


Text or { Text }

Text from the right side of the given text string.

Returns text from the right side of a text string.



Returns "d", the last character of "abcd".

RIGHT("abcd", 2)RIGHT("abcd"; 2)

Returns "cd", the last two characters of "abcd".

RIGHT(TextField1, LEN(TextField1) / 2)RIGHT(TextField1; LEN(TextField1) / 2)

Returns the second half of the value of TextField1. LEN returns the length of a text string.