MSCEWI2021
Unsupported use of parameter "match_arg" detected. Values 'l' and 'x' are not supported in Snowflake. This parameter is used in some regular expressions functions.
Last updated
Unsupported use of parameter "match_arg" detected. Values 'l' and 'x' are not supported in Snowflake. This parameter is used in some regular expressions functions.
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
In Teradata functions like REGEX_SUBSTR, REGEX_REPLACE, or REGEX_INSTR have a parameter called "match_arg", a character argument with the following valid values:
'i'
: case-insensitive matching.
'c'
: case sensitive matching.
'n'
: the period character (match any character) can match the newline character.
'm'
: source string is treated as multiple lines instead of as a single line.
'l'
: if source_string exceeds the current maximum allowed source_string size (currently 16 MB), a NULL is returned instead of an error.
'x'
: ignore whitespace.
The argument can contain more than one character.
In Snowflake, the equivalent argument for these functions is regexp_parameters.
A string of one or more characters that specifies the regular expression parameters used for searching for matches. The supported values are:
c
: case-sensitive.
i
: case-insensitive.
m
: multi-line mode.
e
: extract sub-matches.
s
: the ‘.’ the wildcard also matches the newline character as well.
As it can be seen, values 'i', 'c', 'm'
are the same in both languages, and the 'n'
value in Teradata is mapped to 's'
. However, values 'l', 'x'
don't have an equivalent counterpart. It is in these cases that SnowConvert adds this warning.
Note that warning is also added for each use of this function.
If you need more support, you can email us at