EndsWith Function

  • Updated

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

Syntax 1

 

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

 

EndsWith(string, searchValue)

 

 

Arguments:

 

 

 

string

String - A string.

 

 

searchValue

String - A string.

Syntax 2

 

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

 

EndsWith(string, searchValue, caseSensitive)

 

 

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.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.