REGEX_FIND_ALL

Description

Return all occurrences of strings that match a regular expression in a bag.

Syntax

REGEX_FIND_ALL(string_expression, regex)

Arguments

  string_expression - string expression

  regex - string expression indicating a regular expression

Examples

REGEX_FIND_ALL('abcdefg','[a-d]') returns a bag with the following items: a,b,c,d. 

Return value datatype

Bag

Impact of null value

If string_expression is null, returns null. If regExp is null, an error is raised.