[
https://issues.apache.org/jira/browse/FLINK-35963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
lincoln lee closed FLINK-35963.
-------------------------------
Fix Version/s: 2.0.0
Assignee: Dylan He
Resolution: Fixed
Fixed in master: e8c1d1b9d411e17130a57851c0bbaecb2e816048
> Add REGEXP_SUBSTR function
> --------------------------
>
> Key: FLINK-35963
> URL: https://issues.apache.org/jira/browse/FLINK-35963
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Dylan He
> Assignee: Dylan He
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.0.0
>
>
> Add REGEXP_SUBSTR function.
> ----
> Returns the first substring in {{str}} that matches {{regex}}.
> Example:
> {code:sql}
> > SELECT REGEXP_SUBSTR('Steven Jones and Stephen Smith are the best players',
> > 'Ste(v|ph)en');
> Steven
> > SELECT REGEXP_SUBSTR('Mary had a little lamb', 'Ste(v|ph)en');
> NULL
> {code}
> Syntax:
> {code:sql}
> REGEXP_SUBSTR(str, regex)
> {code}
> Arguments:
> * {{str}}: A STRING expression to be matched.
> * {{regex}}: A STRING expression with a pattern.
> Returns:
> A STRING.
> In case of a malformed {{regex}} the function returns an error.
> If either argument is NULL or the pattern is not found, the result is NULL.
> 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_substr.html]
> *
> [MySQL|https://dev.mysql.com/doc/refman/8.4/en/regexp.html#function_regexp-substr]
> *
> [PostgreSQL|https://www.postgresql.org/docs/16/functions-matching.html#FUNCTIONS-POSIX-REGEXP]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
