padRight

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

Function format

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

• source: the Text value which is padded to the right 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 right of the Text source.
• value: the Text value which is padded to the right of the Text source.

padRight example

padright("123", 5, "00")

The formula returns the Text value 12300.