SSC-FDM-TD0015

Regexp_Substr Function only supports POSIX regular expressions.

This FDM is deprecated, please refer to SSC-EWI-TD0020 documentation

Description

Currently, there is no support in Snowflake for extended regular expression beyond the POSIX Basic Regular Expression syntax.

This EWI is added every time a function call to REGEX_SUBSTR, REGEX_REPLACE, or REGEX_INSTR is transformed to SnowFlake to warn the user about possible unsupported regular expressions. Some of the features not supported are lookahead, lookbehind, and non-capturing groups.

Example Code

Teradata:

SELECT REGEXP_SUBSTR('qaqequ','q(?=u)', 1, 1);

Snowflake Scripting:

SELECT
--** SSC-FDM-TD0015 - REGEXP_SUBSTR FUNCTION ONLY SUPPORTS POSIX REGULAR EXPRESSIONS **
REGEXP_SUBSTR('qaqequ','q(?=u)', 1, 1);

Recommendations

• Check the regular expression used in each case to determine whether it needs manual intervention. More information about expanded regex support and alternatives in SnowFlake can be found here.

• If you need more support, you can email us at [e-mail]