@Ends (Formula Language)

Determines if a substring is at the end of a string.

Syntax

@Ends( string ; substring )

Parameters

string

Text or text string. The string to search.

substring

Text or text string. The string to search for at the end of string.

Return value

flag

Boolean

  • 1 (True) indicates that the substring is at the end of string
  • 0 (False) indicates that the substring is not at the end of string

Usage

This function is case-sensitive.

If the either parameter is a list, the function tests each element of the second parameter against each element of the first parameter and returns 1 if any match occurs.

Examples

  1. This example returns 1.
    @Ends("Hi There";"re")
  2. This example returns 0.
    @Ends("Hi There";"The")
  3. This formula checks to see if the end of the Signature field contains the strings "Owens" or "Irons" or "Baker." If it does, the string Verify Signature is returned; otherwise, the string Don't Verify Signature is returned.
    @If(@Ends(Signature;"Owens":"Irons":"Baker");"Verify signature"; "Don't Verify Signature")