1 of 1

SUBSTR

This page describes the SUBSTR function in Lenses SQL.

SUBSTR(expr, startIndexExpr)

Returns a new string that is a substring of this string.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    SUBSTR(email, 10 , 20),
    email 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "SUBSTR": "aol.com",
    "email": "Jose.Hood@aol.com"
  }
}

This page describes the SUBSTR function in Lenses SQL.

SUBSTR(expr, startIndexExpr)

Returns a new string that is a substring of this string.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    SUBSTR(email, 10 , 20),
    email 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "SUBSTR": "aol.com",
    "email": "Jose.Hood@aol.com"
  }
}