endsWith

Returns true if a string expression field ends with a specific substring, find.

Example

Find all countries in the expression COUNTRYNAME_ that end with the ‘n’ character.

endsWith(SALES.COUNTRIES.COUNTRY_NAME,"n")

Syntax

endsWith(string expr field, string find)

Parameters

• field : string expression to search

• find : string expression to find in field

  Returns

  bool

Notes

Function endsWith evaluates field then searches for find at the end of field. If find is found it returns true. It returns false otherwise. This means if find is found, but not at the end of field, endsWith returns false.

Function endsWith is not case sensitive.