LogoLogo
search
⌘Ctrlk
Homechevron-downProductsDownload Community Edition
  • sidebarLenses DevX
  • signs-postUser Guide
  • plugKafka Connectors
  • right-leftKafka to Kafka Replicator
  • brain-circuitMCP Server
  • rectangle-terminalVS Code Extension
  • terminalAPI Reference
GitBook Assistant
GitBook Assistant
GitBook Assistant
Good afternoon

I'm here to help you with the docs.

⌘Ctrli
AI Based on your contextquestion-circle
LogoLogo
  • hand-waveWelcome
    • lightbulbConcepts
    • signs-postNavigating & Discovering Lenses
    • Configuring Environments
    • Discovering Topics & Schemas
    • Using SQL to query Kafka
    • Process data with SQL Processors
    • Share and replicate data
    • Integrating data with Kafka Connect
    • Register your own Applications
    • MCP Server
    • Security
    • Governance
    • Alerting & Monitoring
    • 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
gitbookPowered by GitBookgitbook
  1. Usingchevron-right
  2. SQL Referencechevron-right
  3. Functions

String

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

ABBREVIATEchevron-rightBASE64chevron-rightCAPITALIZEchevron-rightCENTERchevron-rightCHOPchevron-rightCONCATchevron-rightCONTAINSchevron-rightDECODE64chevron-rightDELETEWHITESPACEchevron-rightDIGITSchevron-rightDROPLEFTchevron-rightDROPRIGHTchevron-rightENDSWITHchevron-rightINDEXOFchevron-rightLENchevron-rightLOWERchevron-rightLPADchevron-rightMKSTRINGchevron-rightREGEXPchevron-rightREGEX_MATCHESchevron-rightREPLACEchevron-rightREVERSEchevron-rightRPADchevron-rightSTARTSWITHchevron-rightSTRIPACCENTSchevron-rightSUBSTRchevron-rightSWAPCASEchevron-rightTAKELEFTchevron-rightTAKERIGHTchevron-rightTRIMchevron-rightTRUNCATEchevron-rightUNCAPITALIZEchevron-rightUPPERchevron-rightUUIDchevron-right
PreviousDUMPchevron-leftNextABBREVIATEchevron-right

Last updated 1 month ago

Was this helpful?

LogoLogo

Resources

  • Privacy
  • Cookies
  • Terms & Conditions
  • Community EULA

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

Was this helpful?