Snowflake Functions
String Functions
regexp_count
returns number of matches of regular expression pattern in subject Supported Signatures
function regexp_count(varchar, varchar) returns decimal(38, 0)
function regexp_count(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
function regexp_count(varchar, varchar, decimal(38, 0), varchar) returns decimal(38, 0)
regexp_instr
returns position at which the subject matches the regular expression pattern Supported Signatures
function regexp_instr(varchar, varchar) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0), varchar) returns decimal(38, 0)
function regexp_instr(varchar, varchar, decimal(38, 0), decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns decimal(38, 0)
regexp_like
returns TRUE if subject RLIKE pattern Supported Signatures
function regexp_like(varchar, varchar) returns boolean
function regexp_like(varchar, varchar, varchar) returns boolean
regexp_replace
replaces substring in subject matching a regular expression pattern Supported Signatures
function regexp_replace(varchar, varchar) returns varchar
function regexp_replace(varchar, varchar, varchar) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0)) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0), decimal(38, 0)) returns varchar
function regexp_replace(varchar, varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns varchar
regexp_substr
returns substring in subject which matches the regular expression pattern Supported Signatures
function regexp_substr(varchar, varchar) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0)) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns varchar
function regexp_substr(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns varchar
regexp_substr_all
returns all substring in subject which matches the regular expression pattern Supported Signatures
function regexp_substr_all(varchar, varchar) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0)) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0)) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar) returns array
function regexp_substr_all(varchar, varchar, decimal(38, 0), decimal(38, 0), varchar, decimal(38, 0)) returns array