DROPLEFT

This page describes the DROPLEFT function in Lenses SQL.

DROPLEFT(expr, lengthExpr)

Removes the left most ’length’ characters from a string expression.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
    DROPLEFT(password_hash, 50),
    password_hash 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "DROPLEFT": "872fd17f01f428",
    "password_hash": "cc53c3b3b0b966804573ceb917390510de95742d7caf3d7474872fd17f01f428"
  }
}