Scalar FunctionsString Functions

extract_all

Extracts all matches for a regular expression from a string.

Syntax

extract_all(regex, source)

Prop

Type

Returns: dynamic

print extract_all("(\\d+)", "Vikings raided in 793 and 845 and 885")

print_0 (dynamic)
["793","845","885"]

extract

Extracts a match for a regular expression from a string.

has

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