Description
The function should search a string for a regular expression pattern and returns it or NULL of it is not found. See other DBMSs:
- Oracle: https://docs.oracle.com/cd/B12037_01/server.101/b10759/functions116.htm
- DB2: https://www.ibm.com/docs/en/db2/11.5?topic=functions-regexp-substr
- Snowflake: https://docs.snowflake.com/en/sql-reference/functions/regexp_substr.html
- BigQuery: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_substr
- Redshift: https://docs.aws.amazon.com/redshift/latest/dg/REGEXP_SUBSTR.html
- MariaDB: https://mariadb.com/kb/en/regexp_substr/
- Exasol DB: https://docs.exasol.com/db/latest/sql_references/functions/alphabeticallistfunctions/regexp_substr.htm
Attachments
Issue Links
- is a clone of
-
SPARK-39618 Add the REGEXP_COUNT function
- Resolved
- is cloned by
-
SPARK-39744 Add the REGEXP_INSTR function
- Resolved
- links to