LogoLogo
Ctrlk
HomeProductsDownload Community Edition
  • Lenses DevX
  • Kafka Connectors
  • Kafka to Kafka Replicator
  • MCPs
  • API Reference
GitBook Assistant
GitBook Assistant
Working...Thinking...
GitBook Assistant
Good night

I'm here to help you with the docs.

Ctrli
AI Based on your context
  • Overview
  • What's New?
  • Getting Started
    • Setting Up Community Edition
    • Connecting Lenses to your Kafka environment
  • Deployment
    • Installation
    • Configuration
    • Upgrade to Lenses 6.1
  • User Guide
    • Environments
    • Lenses Resource Names (LRNs)
    • Identity & Access Management
    • Topics
    • SQL Studio
    • Applications
    • Schemas
    • Monitoring & Alerting
    • Self Service & Governance
    • Topology
    • Tutorials
    • SQL Reference
      • Expressions
      • Functions
        • Aggregate
        • Array
        • Conditions
        • Conversion
        • Date & Time
        • Headers
        • JSON
        • Numeric
        • Nulls
        • Obfuscation
        • Offsets
        • Schema
        • String
          • ABBREVIATE
          • BASE64
          • CAPITALIZE
          • CENTER
          • CHOP
          • CONCAT
          • CONTAINS
          • DECODE64
          • DELETEWHITESPACE
          • DIGITS
          • DROPLEFT
          • DROPRIGHT
          • ENDSWITH
          • INDEXOF
          • LEN
          • LOWER
          • LPAD
          • MKSTRING
          • REGEXP
          • REGEX_MATCHES
          • REPLACE
          • REVERSE
          • RPAD
          • STARTSWITH
          • STRIPACCENTS
          • SUBSTR
          • SWAPCASE
          • TAKELEFT
          • TAKERIGHT
          • TRIM
          • TRUNCATE
          • UNCAPITALIZE
          • UPPER
          • UUID
        • User Defined Functions
        • User Defined Aggregate Functions
      • Deserializers
      • Supported data formats
  • Resources
    • Downloads
    • CLI
Powered by GitBook
On this page
  1. User Guide
  2. SQL Reference
  3. Functions

String

This page describes how to use string functions in Lenses SQL Processors.

ABBREVIATEBASE64CAPITALIZECENTERCHOPCONCATCONTAINSDECODE64DELETEWHITESPACEDIGITSDROPLEFTDROPRIGHTENDSWITHINDEXOFLENLOWERLPADMKSTRINGREGEXPREGEX_MATCHESREPLACEREVERSERPADSTARTSWITHSTRIPACCENTSSUBSTRSWAPCASETAKELEFTTAKERIGHTTRIMTRUNCATEUNCAPITALIZEUPPERUUID
PreviousDUMPNextABBREVIATE

Last updated 1 month ago

Was this helpful?

LogoLogo

Resources

  • Privacy
  • Cookies
  • Terms & Conditions
  • Community EULA

2024 © Lenses.io Ltd. Apache, Apache Kafka, Kafka and associated open source project names are trademarks of the Apache Software Foundation.

Was this helpful?