[ https://issues.apache.org/jira/browse/FLINK-35931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
dalongliu reassigned FLINK-35931: --------------------------------- Assignee: Dylan He > Add REGEXP_EXTRACT_ALL function > ------------------------------- > > Key: FLINK-35931 > URL: https://issues.apache.org/jira/browse/FLINK-35931 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / API > Reporter: Dylan He > Assignee: Dylan He > Priority: Major > > Add REGEXP_EXTRACT_ALL function. > ---- > Extracts all of the strings in {{str}} that match the {{regexp}} expression > and correspond to the regex group {{idx}}. > Example: > {code:sql} > > SELECT REGEXP_EXTRACT_ALL('100-200, 300-400', '(\\d+)-(\\d+)', 1); > [100, 300] > > SELECT REGEXP_EXTRACT_ALL('100-200, 300-400', r'(\d+)-(\d+)', 1); > ["100","300"] > {code} > Syntax: > {code:sql} > REGEXP_EXTRACT_ALL(str, regexp[, idx]) > {code} > Arguments: > * {{str}}: A STRING expression to be matched. > * {{regexp}}: A STRING expression with a matching pattern. > * {{idx}}: An optional INTEGER expression greater or equal 0 with default 1. > Returns: > An ARRAY<STRING>. > {{regexp}} must be a Java regular expression. > When using literals, use `raw-literal` (`r` prefix) to avoid escape character > pre-processing. > {{regexp}} may contain multiple groups. {{idx}} indicates which regex group > to extract. An {{idx}} of 0 means matching the entire regular expression. > See also: > * > [Spark|https://spark.apache.org/docs/3.5.1/sql-ref-functions-builtin.html#string-functions] > * > [Databricks|https://docs.databricks.com/en/sql/language-manual/functions/regexp_extract_all.html] -- This message was sent by Atlassian Jira (v8.20.10#820010)