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": " [email protected]",
"email": "[email protected]"
}
}
Last updated
Was this helpful?