Yandex DataLens

Getting started
Use cases
Step-by-step instructions
Concepts
Access management
- Managing access to DataLens
- Managing access at the data row level
Pricing policy
Function reference
- All Functions
- Aggregate functions
- Date/Time functions
- Geographical functions
- Logical functions
  - Overview
  - CASE
  - IF
  - IFNULL
  - ISNULL
  - ZN
- Text markup functions
- Mathematical functions
  - Overview
  - ABS
  - ACOS
  - ASIN
  - ATAN
  - ATAN2
  - CEILING
  - COS
  - COT
  - DEGREES
  - DIV
  - EXP
  - FLOOR
  - GREATEST
  - LEAST
  - LN
  - LOG
  - LOG10
  - PI
  - POWER
  - RADIANS
  - ROUND
  - SIGN
  - SIN
  - SQRT
  - SQUARE
  - TAN
- Operators
- String functions
- Time series functions
- Type conversion functions
- Window functions
- Function Availability
Questions and answers

REGEXP_REPLACE

Syntax

REGEXP_REPLACE( string, pattern, replace_with )

Description

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.

Use the ClickHouse syntax to create regular expressions in materialized datasets.

Examples

REGEXP_REPLACE("RU 912873", "\s", "-") = "RU-912873"

Data source support

Materialized Dataset, ClickHouse 1.1, MySQL 8.0.12, Oracle Database 12c (12.1), PostgreSQL 9.3.