LPAD

This page describes the LPAD function in Lenses SQL.

LPAD(strExpr, lengthExpr, padExpr)

Prepends the value of padExpr to the value of strExpr until the total length is lengthExpr.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

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

Output:

{
  "value": {
    "LPAD": "                                 [e-mail]",
    "email": "[e-mail]"
  }
}