@RightBack (Formula Language)

Returns the rightmost characters in a string.


@RightBack( stringToSearch ; numberOfChars )

@RightBack( stringToSearch ; subString )



Text or text list. The string whose rightmost characters you want to find.


Number. Counting from left to right, the number of characters to skip. All the characters following that number are returned.


Text. A substring of stringToSearch. @RightBack returns all the characters following subString. It finds subString by searching stringToSearch from right to left.

Return value


Text or text list. The rightmost characters in stringToSearch. The number of characters returned is determined by either numberOfChars or subString.


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.


  1. This example returns "nard Wallace."
    @RightBack("Lennard Wallace";3) 
  2. This example returns a blank.
    @RightBack("Lennard Wallace";"")
  3. This example returns "Wallace."
    @RightBack("Lennard Wallace";" ")
  4. This example returns "othy Altman" if the name in the field named Author is Timothy Altman.
  5. This example returns lapalooza if the word in the show field is Lalapalooza.
  6. This example returns palooza if the word in the show field is lalapalooza.
    Note: @RightBack returns the string to the right of the last occurrence of the substring you are searching for.
  7. This example returns "nard" and "lace" in a list.
    @RightBack("Lennard" : "Wallace"; 3)