⌘Ctrlk

Home Products Download Community Edition

Lenses DevX
User Guide
Kafka Connectors
Kafka to Kafka Replicator
MCP Server
VS Code Extension
API Reference
Changelog

GitBook Assistant

Good afternoon

I'm here to help you with the docs.

⌘Ctrli

AI Based on your context

Welcome
- Concepts
- Navigating & Discovering Lenses

Powered by GitBook

For the complete documentation index, see llms.txt. This page is also available as Markdown.

User Guide
Using
SQL Reference
Functions

String

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

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

PreviousDUMP NextABBREVIATE

Last updated 3 months ago

Was this helpful?

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?