Rpad

Use the Rpad expression type to pad the right side of a string with a specific set of characters up to a given length. When you specify a value for a length that is shorter than the length of the expression, then Rpad truncates the expression to the specified length. A space is the default padding character when no character to pad is specified.

Use parameters that follow this form: rpad(Dimension, length, "characters to pad"). For example, to pad the account value of 1234 on the right side with zeros up to six characters in length, specify: rpad(Dimension, 6, "0") as the expression. In this example, the result is 123400.