padLeft

Use the padLeft function to pad a Text value to the left with another Text value. The padLength function returns a Text value which is of a target length you specify.

Function format

padLeft(Text source, Integer target length, Text value)

• source: the Text value which is padded to the left with the second Text value parameter.
• target length: the length of the Text value the function returns. If the Text source and the padded Text does not meet the target length, the Text is repeated to the left of the Text source.
• value: the Text value which is padded to the left of the Text source.

padLeft example

padLeft("123", 5, "00")

The formula returns the Text value 00123.