1 of 1

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": "                                 Jose.Hood@aol.com",
    "email": "Jose.Hood@aol.com"
  }
}