To fill up a given length with given padding at the beginning
With this function, you fill a text at the beginning, i.e. to the left of the text, with one or more given 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.
lpad(string, number, string)
lpad(myText, length, padding)To fill up a given length with given padding at the beginning, if the given text is shorter than the given length.
lpad("A text", 20, "+ ")
Result: + + + + + + + A text
lpad(text(123), 8, "0")