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)

🔗 Official Documentation

`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)

🔗 Official Documentation

`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

🔗 Official Documentation

`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

🔗 Official Documentation

`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

🔗 Official Documentation

`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

🔗 Official Documentation

Reference

SQL Functions

String Functions

`regexp_count`

`regexp_instr`

`regexp_like`

`regexp_replace`

`regexp_substr`

`regexp_substr_all`

​regexp_count

​regexp_instr

​regexp_like

​regexp_replace

​regexp_substr

​regexp_substr_all

`regexp_count`

`regexp_instr`

`regexp_like`

`regexp_replace`

`regexp_substr`

`regexp_substr_all`