Related Links
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.


rpad(string, number, string)




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.
Last modified 2mo ago
Export as PDF
Copy link