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

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

Was this helpful?

  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 27 days 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.