RuleGo RuleGo
🏠Home
  • Quick Start
  • Rule Chain
  • Standard Components
  • Extension Components
  • Custom Components
  • Visualization
  • RuleGo-Server
  • RuleGo-MCP-Server
  • AOP
  • Trigger
  • Advanced Topics
  • Performance
  • Standard Components
  • Extension Components
  • Custom Components
  • Components Marketplace
  • Overview
  • Quick Start
  • Routing
  • DSL
  • API
  • Options
  • Components
🔥Editor (opens new window)
  • RuleGo Editor (opens new window)
  • RuleGo Server (opens new window)
  • StreamSQL
  • Github (opens new window)
  • Gitee (opens new window)
  • Changelog (opens new window)
  • English
  • 简体中文
🏠Home
  • Quick Start
  • Rule Chain
  • Standard Components
  • Extension Components
  • Custom Components
  • Visualization
  • RuleGo-Server
  • RuleGo-MCP-Server
  • AOP
  • Trigger
  • Advanced Topics
  • Performance
  • Standard Components
  • Extension Components
  • Custom Components
  • Components Marketplace
  • Overview
  • Quick Start
  • Routing
  • DSL
  • API
  • Options
  • Components
🔥Editor (opens new window)
  • RuleGo Editor (opens new window)
  • RuleGo Server (opens new window)
  • StreamSQL
  • Github (opens new window)
  • Gitee (opens new window)
  • Changelog (opens new window)
  • English
  • 简体中文

广告采用随机轮播方式显示 ❤️成为赞助商
  • Quick Start

  • Rule Chain

  • Standard Components

  • Extension Components

  • Custom Components

  • Components marketplace

  • Visualization

  • AOP

  • Trigger

  • Advanced Topic

  • RuleGo-Server

  • FAQ

  • Endpoint Module

  • Support

  • StreamSQL

    • Overview
    • Quick Start
    • Core Concepts
    • SQL Reference
    • API Reference
    • RuleGo Integration
    • functions

      • Aggregate Functions
      • Analytical Functions
      • Window Functions
      • Math Functions
      • String Functions
        • Basic String Functions
          • UPPER - Uppercase Function
          • LOWER - Lowercase Function
          • CONCAT - String Concatenation Function
          • LENGTH - String Length Function
          • SUBSTRING - Substring Function
          • TRIM - Trim Function
          • LTRIM - Left Trim Function
          • RTRIM - Right Trim Function
          • FORMAT - Format Function
        • String Check Functions
          • ENDSWITH - Ends With Function
          • STARTSWITH - Starts With Function
          • INDEXOF - Find Position Function
        • String Manipulation Functions
          • REPLACE - Replace Function
          • SPLIT - Split Function
          • LPAD - Left Padding Function
          • RPAD - Right Padding Function
        • Regular Expression Functions
          • REGEXP_MATCHES - Regex Match Function
          • REGEXP_REPLACE - Regex Replace Function
          • REGEXP_SUBSTRING - Regex Extract Function
        • 📚 Related Documentation
      • Conversion Functions
      • DateTime Functions
      • JSON Functions
      • Hash Functions
      • Array Functions
      • Type Check Functions
      • Conditional Functions
      • Multi-row Functions
      • Expression Functions
      • Custom Functions
    • case-studies

目录

String Functions

# StreamSQL String Functions

String functions are used for text processing.

# Basic String Functions

# UPPER - Uppercase Function

Syntax: upper(str)
Description: Converts a string to uppercase.

# LOWER - Lowercase Function

Syntax: lower(str)
Description: Converts a string to lowercase.

# CONCAT - String Concatenation Function

Syntax: concat(str1, str2, ...)
Description: Concatenates multiple strings.

# LENGTH - String Length Function

Syntax: length(str)
Description: Returns the length of a string.

# SUBSTRING - Substring Function

Syntax: substring(str, start, [length])
Description: Extracts a substring from a string.

# TRIM - Trim Function

Syntax: trim(str)
Description: Removes spaces from both ends of a string.

# LTRIM - Left Trim Function

Syntax: ltrim(str)
Description: Removes spaces from the left side of a string.

# RTRIM - Right Trim Function

Syntax: rtrim(str)
Description: Removes spaces from the right side of a string.

# FORMAT - Format Function

Syntax: format(format_str, ...)
Description: Formats a string according to the specified format.

# String Check Functions

# ENDSWITH - Ends With Function

Syntax: endswith(str, suffix)
Description: Checks if a string ends with the specified suffix.

# STARTSWITH - Starts With Function

Syntax: startswith(str, prefix)
Description: Checks if a string starts with the specified prefix.

# INDEXOF - Find Position Function

Syntax: indexof(str, substring)
Description: Returns the position of a substring within a string.

# String Manipulation Functions

# REPLACE - Replace Function

Syntax: replace(str, old_str, new_str)
Description: Replaces specified content in a string.

# SPLIT - Split Function

Syntax: split(str, delimiter)
Description: Splits a string using a delimiter.

# LPAD - Left Padding Function

Syntax: lpad(str, length, pad_str)
Description: Pads characters to the left of a string to the specified length.

# RPAD - Right Padding Function

Syntax: rpad(str, length, pad_str)
Description: Pads characters to the right of a string to the specified length.

# Regular Expression Functions

# REGEXP_MATCHES - Regex Match Function

Syntax: regexp_matches(str, pattern)
Description: Checks if a string matches a regular expression.

# REGEXP_REPLACE - Regex Replace Function

Syntax: regexp_replace(str, pattern, replacement)
Description: Replaces string content using regular expressions.

# REGEXP_SUBSTRING - Regex Extract Function

Syntax: regexp_substring(str, pattern)
Description: Extracts string content using regular expressions.

# 📚 Related Documentation

  • Math Functions - Learn detailed usage of math functions
  • Conversion Functions - Learn detailed usage of conversion functions
  • SQL Reference - View complete SQL syntax reference
Edit this page on GitHub (opens new window)
Last Updated: 2025/08/05, 02:24:31
Math Functions
Conversion Functions

← Math Functions Conversion Functions→

Theme by Vdoing | Copyright © 2023-2025 RuleGo Team | Apache 2.0 License

  • 跟随系统
  • 浅色模式
  • 深色模式
  • 阅读模式