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 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
  • 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
    • Upgrade to Lenses 6
  • Resources
    • Downloads
    • CLI
    • API Reference
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 1 year 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.