Contains

Checks if a supplied string contains 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

Contains( <Text> , <Search Text> )

* 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

Examples

This example returns true by finding that the input string "Apple" contains the sub-string "pp"

Contains("Apple", "pp")