Scalar FunctionsString Functions

has_cs

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

Syntax

text has_cs lookup

Negated form:

text !has_cs lookup

Function call syntax:

has_cs(text, lookup)

Prop

Type

Returns: bool

print "Harald Fairhair united Norway" has_cs "Fairhair"

print_0 (bool)
true

has_any_index

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

hasprefix

Indicate whether a string starts with a word prefix (case-insensitive, word boundary matching).