1 of 1

TAKERIGHT

This page describes the TAKERIGHT function in Lenses SQL.

TAKERIGHT(expr, lengthExpr)

Returns the rightmost ’length’ characters from a string expression

Available in:

Processors

SQL Studio

✓

Sample code:

USE `kafka`;
SELECT 
    TAKERIGHT(first_name, 3), 
    first_name 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "TAKERIGHT": "ose",
    "first_name": "Jose"
  }
}

This page describes the TAKERIGHT function in Lenses SQL.

TAKERIGHT(expr, lengthExpr)

Returns the rightmost ’length’ characters from a string expression

Available in:

Processors

SQL Studio

✓

Sample code:

USE `kafka`;
SELECT 
    TAKERIGHT(first_name, 3), 
    first_name 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "TAKERIGHT": "ose",
    "first_name": "Jose"
  }
}