EndsWith (PQL)

Checks if a supplied string ends with the sub-string.

• Returned Output: Boolean
• Library: PQL \ Common \ String
• Version: 2018.00.000
• Compatibility:
  • Can be combined with and other PQL function throughout the application.
  • It CANNOT be used with MDX or VBA functions. But it can be used on MDX-based content in other parts of the application.

Syntax

* Click on the function's arguments above for more details on the input values.

Comments

• The text and search text strings can be any alphanumeric set of characters.
• The method returns true if the result is positive. Otherwise it returns false.

Different Function types

• This function is similar to the Excel find function.
• See related functions: Equals, StartsWith, Contains,

Examples

This example returns false because the input string "Apple" does NOT end with the sub-string "pp"

EndsWith("Apple", "pp")