@Right (Formula Language)
Returns the rightmost characters in the string. You can specify the number of rightmost characters you want returned, or you can indicate that you want all the characters following a specific substring.
Syntax
@Right( stringToSearch ; numberOfChars ) or @Right( stringToSearch ; subString )
Parameters
stringToSearch
Text or text list. The string whose rightmost characters you want to find.
numberOfChars
Number. The number of characters to return. If the number is 2, the last two characters of stringToSearch are returned; if the number is 5, the last five characters are returned, and so on.
subString
Text. A substring of stringToSearch. @Right returns all of the characters to the right of subString. It finds subString by searching stringToSearch from left to right.
Return value
resultString
Text or text list. The rightmost characters in stringToSearch. The number of characters returned is determined by either numberOfChars or subString. @Right returns "" if subString is not found in stringToSearch.
Usage
If the first parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.
Examples
- This example returns "ace," the rightmost 3 characters in the
string.
@Right("Lennard Wallace";3) - This example returns "Wallace," which represents everything to
the right of the first occurrence of the blank space.
@Right("Lennard Wallace";" ") - This example returns "man" if the Author field contains "Timothy
Altman."
@Right(Author;3) - This example returns "Altman" if the Author field contains "Timothy
Altman."
@Right(Author;" ") - This example returns "ard" and "ace" in a list.
@Right("Lennard" : "Wallace";3)