rpad

To fill up a given length with a given padding at the end

With this function, you fill a text at the end, i.e. to the right of the text, with one or more specified characters up to the desired total length. The given characters are repeated until the given total length is reached.

This can be very useful when - for technical reasons - data must have a certain length, or for optical padding in print layouts in a non-proportional font.

If the source text already reaches or exceeds the specified length, it remains unchanged.

Syntax

rpad(string, number, string)

Return

string

Examples

rpad(myText, length, padding) To fill up a given length with given padding at the end, if the given text is shorter than the given length.

rpad("A text", 20, " +")

Result: A text + + + + + + +

rpad(text(123), 8, "0")

Result: 12300000

See also

lpad, which fills up a given length with given padding at the beginning.