REGEXP_REPLACE

Replace regex matches.

Category: String Functions

Syntax

REGEXP_REPLACE(str, pattern, replacement)

Arguments

  • str varchar Input string value.
  • pattern varchar Regular expression pattern to match in the input string.
  • replacement varchar Replacement text used for matched content.

Returns

blob — Returns the computed result as blob.