1 of 1

INDEXOF

This page describes the INDEXOF function in Lenses SQL.

INDEXOF(expr, substringExpr)

Returns the index of a substring in an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    INDEXOF(email,'@'), 
    email 
FROM users-topic
LIMIT 1;

Output:

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

This page describes the INDEXOF function in Lenses SQL.

INDEXOF(expr, substringExpr)

Returns the index of a substring in an expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    INDEXOF(email,'@'), 
    email 
FROM users-topic
LIMIT 1;

Output:

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