Skip to main content

​
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.
Last modified on April 20, 2026