LogoLogo
Ctrlk
HomeProductsDownload Community Edition
  • Lenses DevX
  • Kafka Connectors
  • Kafka to Kafka Replicator
  • MCPs
  • API Reference
  • 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 11 months 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.