LogoLogo
search
Ctrlk
Homechevron-downProductsDownload Community Edition
  • sidebarLenses DevX
  • plugKafka Connectors
  • right-leftKafka to Kafka Replicator
  • brain-circuitMCPs
  • terminalAPI 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 contextquestion-circle
LogoLogo
  • 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
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. User Guidechevron-right
  2. Lenses SQLchevron-right
  3. SQL Referencechevron-right
  4. 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 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.

Was this helpful?