Text.PadEnd
Syntax
Text.PadEnd(text as nullable text, count as number, optional character as nullable text) as nullable text
About
Returns a text
value padded to length count
by inserting spaces at the end of the text value text
. An optional character character
can be used to specify the character used for padding. The default pad character is a space.
Example 1
Pad the end of a text value so it is 10 characters long.
Usage
Text.PadEnd("Name", 10)
Output
"Name "
Example 2
Pad the end of a text value with "|" so it is 10 characters long.
Usage
Text.PadEnd("Name", 10, "|")
Output
"Name||||||"