New Text Function: Contains

Builtin & User functions
Not right now

Similar to the existing Index function, I would love to see a new Contains function to be used in expressions.

It would sit in Built-in Functions > Text, and be something along the following:

Contains(t, search)

Contains function : data type Boolean

Returns a value indicating whether a specified substring occurs within this string. Returns true if the search parameter occurs within this string, or if search is the empty string (""); otherwise, false.


t : mandatory; data type Text

The Text where the search Text can be found.

search: mandatory; data type Text

The Text string to be found.

Created on 13 Jul 2018
Comments (3)

Changed the category to Builtin & User functions

What's the advantage over using Index(a, b) >= 0 ?


Changed the status to
Not right now

Hi Russell,

Currently we have that use case covered by using the Index function.

That's why, at this moment, we will not implement another function for the same purpose.

Thanks for sharing and continue those ideas coming.