EndsWith Function

Determines if a text string or expression ends with another text string or expression.

Syntax 1

EndsWith(string, searchValue)

Determines if a text string or expression ends with another text string or expression.

Arguments

string String - A string.

searchValue String - A string.

Syntax 2

EndsWith(string, searchValue, caseSensitive)

Determines if a text string or expression ends with another text string or expression.

Arguments

string String - A string.

searchValue String - A string.

caseSensitive Boolean - True for a case-sensitive search. If omitted, false (case-insensitive search) is used.

Remarks

Example:

EndsWith("Rate is higher in Hawaii", "Alaska"); // returns false

Example:

EndsWith("Rate is higher in Hawaii", "Hawaii"); // returns true

Example:

EndsWith("Rate is higher in Hawaii", "hawaii"); // returns true

Example:

EndsWith("Rate is higher in Hawaii", "hawaii", true); // returns false