RPAD

This page describes the REGEX_MATCHES function in Lenses SQL.

RPAD(strExpr, lengthExpr, padExpr)

Appends 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 
    RPAD(email, 50, ' '), 
    email 
FROM users-topic
LIMIT 1;

Output:

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