Scalar FunctionsString Functions

has

Indicate whether a string contains a whole word (case-insensitive, word boundary matching).

Syntax

text has lookup

Negated form:

text !has lookup

Function call syntax:

has(text, lookup)

Prop

Type

Returns: bool

print "Bjorn Ironside sailed the Mediterranean" has "ironside"

print_0 (bool)
true

extract_all

Extracts all matches for a regular expression from a string.

has_any_index

Returns the index of the first matching value in the source string.