REGEXEXTRACT
Returns first matching substrings according to a regular expression.
Usage examples
REGEXEXTRACT("hello 123 world", "\d+")
Syntax
REGEXEXTRACT ( value, regex )
-
value- any string expression. -
regex- any string expression that will be used for extracting.
Returns
string - the first matching substring.