regexp_replace.md

description
Finds strings that match the given regular expression and replaces the strings with the given string.

REGEXP_REPLACE

Syntax

REGEXP_REPLACE(input string, regex string, replacement_string string) → string

• input: The expression to search for a matching string.
• regex: The Perl-compatible regular expression (PCRE) to match against.
• replacement_string: The string with which to replace the matching string.

Examples

{% code title="REGEXP_REPLACE example" %}

SELECT REGEXP_REPLACE('8AM-4PM', '\Q-\E', ' to ')
-- EXPR$0
  -- 8AM to 4PM

{% endcode %}

{% code title="REGEXP_REPLACE example" %}

SELECT REGEXP_REPLACE(Address, '\QST\E', 'STREET') 
FROM eth.recent_blocks 
LIMIT 3

-- Raw data
  -- 800 Block of BRYANT ST
  -- 800 Block of BRYANT ST
  -- KEITH ST / SHAFTER AV

-- Returned data
  -- 800 Block of BRYANT STREET
  -- 800 Block of BRYANT STREET
  -- KEITH STREET / SHAFTER AV

{% endcode %}