Scalar FunctionsString Functions

has_any_index

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

Syntax

has_any_index(source, lookups)

Prop

Type

Returns: long

print has_any_index(
  "The longship Naglfar sailed to Lindisfarne",
  "Kattegat",
  "Lindisfarne",
  "York"
)

print_0 (long)
31

print has_any_index("The longship Naglfar sailed to Lindisfarne", "Paris", "York", "Dublin")

print_0 (long)
-1

has

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

has_cs

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