- Release Notes and Announcements
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Resource Management
- Permission Management
- Log Collection
- Collection Overview
- Collecting Logs in Self-Built Kubernetes Cluster
- Collecting Syslog
- Collection by LogListener
- Collecting Text Log
- Uploading Log over Kafka
- Uploading Logs via Anonymous Write
- Uploading Logs via Logback Appender
- Uploading Logs via Log4j Appender
- Uploading Log via SDK
- Uploading Log via API
- Importing Data
- Tencent Cloud Service Log Access
- Metric Collection
- Log Storage
- Metric Storage
- Search and Analysis (Log Topic)
- Syntax and Rules
- Statistical Analysis (SQL)
- Quick Analysis
- SQL Syntax
- SQL Functions
- String Function
- Date and Time Functions
- IP Geographic Function
- URL Function
- Mathematical Calculation Functions
- Mathematical Statistical Function
- General Aggregate Function
- Geospatial Function
- Binary String Function
- Estimation Function
- Type Conversion Function
- Logical Function
- Operators
- Bitwise Operation
- Regular Expression Function
- Lambda Function
- Conditional Expressions
- Array Functions
- Interval-Valued Comparison and Periodicity-Valued Comparison Functions
- JSON Functions
- Window Functions
- Sampling Analysis
- Configuring Indexes
- Reindexing
- Context Search and Analysis
- Downloading Log
- Search and Analysis (Metric Topic)
- Dashboard
- Data Processing documents
- Data Processing
- Creating Processing Task
- Viewing Data Processing Details
- Data Processing Functions
- Function Overview
- Key-Value Extraction Functions
- Enrichment Functions
- Flow Control
- Row Processing Functions
- Field Processing Functions
- Value Structuring Functions
- Regular Expression Processing Functions
- Time Value Processing Functions
- String Processing Functions
- Type Conversion Functions
- Logical and Mathematical Functions
- Encoding and Decoding Functions
- IP Parsing Functions
- Processing Cases
- Scheduled SQL Analysis
- SCF
- Data Processing
- Shipping and Consumption
- Monitoring Alarm
- Historical Documentation
- Practical Tutorial
- Developer Guide
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Topic Management APIs
- Log Set Management APIs
- Index APIs
- Topic Partition APIs
- Machine Group APIs
- Collection Configuration APIs
- Log APIs
- Metric APIs
- Alarm Policy APIs
- Data Processing APIs
- Kafka Protocol Consumption APIs
- CKafka Shipping Task APIs
- Kafka Data Subscription APIs
- COS Shipping Task APIs
- SCF Delivery Task APIs
- Scheduled SQL Analysis APIs
- COS Data Import Task APIs
- Data Types
- Error Codes
- FAQs
- CLS Service Level Agreement
- CLS Policy
- Contact Us
- Glossary
- Release Notes and Announcements
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Resource Management
- Permission Management
- Log Collection
- Collection Overview
- Collecting Logs in Self-Built Kubernetes Cluster
- Collecting Syslog
- Collection by LogListener
- Collecting Text Log
- Uploading Log over Kafka
- Uploading Logs via Anonymous Write
- Uploading Logs via Logback Appender
- Uploading Logs via Log4j Appender
- Uploading Log via SDK
- Uploading Log via API
- Importing Data
- Tencent Cloud Service Log Access
- Metric Collection
- Log Storage
- Metric Storage
- Search and Analysis (Log Topic)
- Syntax and Rules
- Statistical Analysis (SQL)
- Quick Analysis
- SQL Syntax
- SQL Functions
- String Function
- Date and Time Functions
- IP Geographic Function
- URL Function
- Mathematical Calculation Functions
- Mathematical Statistical Function
- General Aggregate Function
- Geospatial Function
- Binary String Function
- Estimation Function
- Type Conversion Function
- Logical Function
- Operators
- Bitwise Operation
- Regular Expression Function
- Lambda Function
- Conditional Expressions
- Array Functions
- Interval-Valued Comparison and Periodicity-Valued Comparison Functions
- JSON Functions
- Window Functions
- Sampling Analysis
- Configuring Indexes
- Reindexing
- Context Search and Analysis
- Downloading Log
- Search and Analysis (Metric Topic)
- Dashboard
- Data Processing documents
- Data Processing
- Creating Processing Task
- Viewing Data Processing Details
- Data Processing Functions
- Function Overview
- Key-Value Extraction Functions
- Enrichment Functions
- Flow Control
- Row Processing Functions
- Field Processing Functions
- Value Structuring Functions
- Regular Expression Processing Functions
- Time Value Processing Functions
- String Processing Functions
- Type Conversion Functions
- Logical and Mathematical Functions
- Encoding and Decoding Functions
- IP Parsing Functions
- Processing Cases
- Scheduled SQL Analysis
- SCF
- Data Processing
- Shipping and Consumption
- Monitoring Alarm
- Historical Documentation
- Practical Tutorial
- Developer Guide
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Topic Management APIs
- Log Set Management APIs
- Index APIs
- Topic Partition APIs
- Machine Group APIs
- Collection Configuration APIs
- Log APIs
- Metric APIs
- Alarm Policy APIs
- Data Processing APIs
- Kafka Protocol Consumption APIs
- CKafka Shipping Task APIs
- Kafka Data Subscription APIs
- COS Shipping Task APIs
- SCF Delivery Task APIs
- Scheduled SQL Analysis APIs
- COS Data Import Task APIs
- Data Types
- Error Codes
- FAQs
- CLS Service Level Agreement
- CLS Policy
- Contact Us
- Glossary
This document introduces the basic syntax and examples of regular expression functions.
CLS supports the following regular expression functions:
Function | Syntax | Description |
regexp_extract_all(x, regular expression) | Extracts the substrings that match a specified regular expression from a specified string and returns a collection of all matched substrings. | |
| regexp_extract_all(x, regular expression, n) | Extracts the substrings that match a specified regular expression from a specified string and returns a collection of substrings that match the target capture group. |
regexp_extract(x, regular expression) | Extracts and returns the first substring that matches a specified regular expression from a specified string. | |
| regexp_extract(x, regular expression, n) | Extracts the substrings that match a specified regular expression from a specified string and returns the first substring that matches the target capture group. |
regexp_like(x, regular expression) | Checks whether a specified string matches a specified regular expression. | |
regexp_replace(x, regular expression) | Deletes the substrings that match a specified regular expression from a specified string and returns the substrings that are not deleted. | |
| regexp_replace(x, regular expression, replace string) | Replaces the substrings that match a specified regular expression in a specified string and returns the new string after the replacement. |
regexp_split(x, regular expression) | Splits a specified string into multiple substrings by using a specified regular expression and returns a collection of the substrings. | |
regexp_extract_all
The
regexp_extract_all function is used to extract the substrings that match a specified regular expression from a specified string.Syntax
Extract the substrings that match a specified regular expression from a specified string and return a collection of all matched substrings.
regexp_extract_all(x, regular expression)
Extract the substrings that match a specified regular expression from a specified string and return a collection of substrings that match the target capture group.
regexp_extract_all(x, regular expression, n)
Parameter description
Parameter | Description |
x | The parameter value is of the varchar type. |
regular expression | The regular expression that contains capture groups. For example, (\\d)(\\d)(\\d) indicates three capture groups. |
n | The nth capture group. n is an integer that starts from 1. |
Return value type
Array
Example
Extract all numbers from the value of the
http_protocol field.Query and analysis statement
* | SELECT regexp_extract_all(http_protocol, '\\d+')
Query and analysis result
[1,1]
regexp_extract
The
regexp_extract function is used to extract the first substring that matches a specified regular expression from a specified string.Syntax
Extract and return the first substring that matches a specified regular expression from a specified string.
regexp_extract(x, regular expression)
Extract the substrings that match a specified regular expression from a specified string and return the first substring that matches the target capture group.
regexp_extract(x, regular expression, n)
Parameter description
Parameter | Description |
x | The parameter value is of the varchar type. |
regular expression | The regular expression that contains capture groups. For example, (\\d)(\\d)(\\d) indicates three capture groups. |
n | The nth capture group. n is an integer that starts from 1. |
Return value type
Varchar
Example
Example 1. Extract the first number from the value of the http_protocol field
Query and analysis statement
* | SELECT regexp_extract_all(http_protocol, '\\d+')
Query and analysis result
1
Example 2. Extract the file information from the value of the request_uri field and count the number of times each file is accessed
Query and analysis statement
* | select regexp_like(server_protocol, '\\d+')
Query and analysis result
regexp_like
The
regexp_like function is used to check whether a specified string matches a specified regular expression.Syntax
regexp_like (x, regular expression)
Parameter description
Parameter | Description |
x | The parameter value is of the varchar type. |
regular expression | Regular expression. |
Return value type
Boolean
Example
Check whether the value of the
server_protocol field contains digits.Query and analysis statement
* | select regexp_like(server_protocol, '\\d+')
Query and analysis result
TRUE
regexp_replace
The
regexp_replace function is used to delete or replace the substrings that match a specified regular expression in a specified string.Syntax
Delete the substrings that match a specified regular expression from a specified string and return the substrings that are not deleted.
regexp_replace (x, regular expression)
Replace the substrings that match a specified regular expression in a specified string and return the new string after the replacement.
regexp_replace (x, regular expression, replace string)
Parameter description
Parameter | Description |
x | The parameter value is of the varchar type. |
regular expression | Regular expression. |
replace string | Substring that is used to replace the matched substring. |
Return value type
String
Example
Delete the version number in the value of the
server_protocol field and calculate the number of requests for each communication protocol.Query and analysis statement
* | select regexp_replace(server_protocol, '.\\d+') AS server_protocol, count(*) AS count GROUP BY server_protocol
Query and analysis result
server_protocol | count |
HTTP | 357 |
regexp_split
The
regexp_split function is used to split a specified string into multiple substrings and return a collection of the substrings.Syntax
regexp_split (x, regular expression)
Parameter description
Parameter | Description |
x | The parameter value is of the varchar type. |
regular expression | Regular expression. |
Return value type
Array
Example
Split the value of the
server_protocol field with forward slashes (/).Query and analysis statement
* | select regexp_split(server_protocol, '/')
Query and analysis result
["HTTP","1.1"]
Yes
No
Was this page helpful?