@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

  1. This example returns "ace," the rightmost 3 characters in the string.
    @Right("Lennard Wallace";3)
  2. This example returns "Wallace," which represents everything to the right of the first occurrence of the blank space.
    @Right("Lennard Wallace";" ")
  3. This example returns "man" if the Author field contains "Timothy Altman."
    @Right(Author;3)
  4. This example returns "Altman" if the Author field contains "Timothy Altman."
    @Right(Author;" ")
  5. This example returns "ard" and "ace" in a list.
    @Right("Lennard" : "Wallace";3)