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_EXTRACT

Syntax

REGEXP_EXTRACT( string, pattern )

Description

Returns the substring string that matches the regular expression pattern pattern.

Argument types:

string — String
pattern — String

Return type: String

Note

Only constant values are accepted for arguments (pattern).

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_EXTRACT("RU 912873", "[A-Z]+\s+(\d+)") = "912873"

Data source support

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