Text.PadStart
Returns text of a specified length by padding the start of the given text.
Syntax
Text.PadStart(
text as text,
count as number,
optional character as text
) as text
Remarks
Returns a text
value padded to length count
by inserting spaces at the start 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.
Examples
Example #1
Pad the start of a text value so it is 10 characters long.
Text.PadStart("Name", 10)
Result:
" Name"
Example #2
Pad the start of a text value with "|" so it is 10 characters long.
Text.PadStart("Name", 10, "|")
Result:
"||||||Name"
Category
Text.Transformations