LogoLogo
CtrlK
HomeProductsDownload Community Edition
  • Lenses DevX
  • Kafka Connectors
  • Kafka to Kafka Replicator
  • MCPs
  • API Reference
  • Overview
  • Learn
  • What’s New?
  • Getting Started
    • Quick Start
    • Connecting Lenses to your environment
  • Deployment
    • Installation
    • Configuration
  • User Guide
    • Topics
    • Schemas
    • Connectors
    • Monitoring & Alerting
    • Self Service & Governance
    • Lenses SQL
      • SQL Studio
      • SQL Processors
      • 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
    • Topology
    • License
    • CLI
  • Resources
    • Support & Community
    • Tutorials
    • Downloads
    • API Reference
Powered by GitBook
On this page

Was this helpful?

  1. User Guide
  2. Lenses SQL
  3. SQL Reference
  4. 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.