Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
    • Neuroanalyst for creating calculated fields
      • 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
  • DataLens Gallery
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. String functions
  4. REPLACE

REPLACE (string)

Written by
Yandex Cloud
Improved by
amatol
Updated at December 19, 2025
View in Markdown

Function REPLACE is also found in the following categories: Array functions.

SyntaxSyntax

REPLACE( string, substring, replace_with )

DescriptionDescription

Searches for the substring substring in the string string and replaces it with the string replace_with.

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

Argument types:

  • string — String
  • substring — String
  • replace_with — String

Return type: String

ExampleExample

REPLACE("350 RUB", "RUB", "USD") = "350 USD"

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Trino, Yandex Documents, YDB.

Was the article helpful?

Previous
REGEXP_REPLACE
Next
RIGHT
© 2026 Direct Cursus Technology L.L.C.