Scalar FunctionsString Functions

extract

Extracts a match for a regular expression from a string.

Syntax

extract(regex, capture_group, source)

Prop

Type

Returns: string

print extract("(\\d+)", 1, "Raid on Lindisfarne in 793 AD")

print_0 (string)
793

endswith_cs

Indicate whether a string ends with another string (case-sensitive).

extract_all

Extracts all matches for a regular expression from a string.