Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
    • Yandex Cloud Partner program
  • Blog
  • Pricing
  • Documentation
© 2025 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
      • All Functions
        • Overview
        • ASCII
        • CHAR
        • CONCAT
        • CONTAINS
        • ENDSWITH
        • FIND
        • ICONTAINS
        • IENDSWITH
        • ISTARTSWITH
        • LEFT
        • LEN
        • LOWER
        • LTRIM
        • REGEXP_EXTRACT
        • REGEXP_EXTRACT_ALL
        • REGEXP_EXTRACT_NTH
        • REGEXP_MATCH
        • REGEXP_REPLACE
        • REPLACE
        • RIGHT
        • RTRIM
        • SPACE
        • SPLIT
        • STARTSWITH
        • SUBSTR
        • TRIM
        • UPPER
        • UTF8
      • Function Availability
    • Parameters
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. String functions
  4. REGEXP_REPLACE

REGEXP_REPLACE

Written by
Yandex Cloud
Improved by
amatol
Updated at November 6, 2024

SyntaxSyntax

REGEXP_REPLACE( string, pattern, replace_with )

DescriptionDescription

Searches for a substring in the string string using the regular expression pattern pattern and replaces it with the string replace_with.

If the substring is not found, the string is not changed.

Argument types:

  • string — String
  • pattern — String
  • replace_with — String

Return type: String

Note

See the documentation of the data source to clarify the regular expression syntax. For example, ClickHouse uses the RE2 syntax to compose regular expressions.

ExampleExample

REGEXP_REPLACE("123 456", "\s", "-") = "123-456"

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, MySQL 8.0.12, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents.

Was the article helpful?

Previous
REGEXP_MATCH
Next
REPLACE
© 2025 Direct Cursus Technology L.L.C.