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.