1 of 1

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