Text.PadEnd
This function returns a text string that has been expanded to a specific length by adding spaces at the end of the original text. You may also choose to use a different character for padding by specif...
Text.PadEnd(text as nullable text, count as number, optional character as nullable text) as nullable textThis function returns a text string that has been expanded to a specific length by adding spaces at the end of the original text. You may also choose to use a different character for padding by specifying the optional character argument. If no character is specified, spaces will be used as the default padding character.
Add characters to the end of a text value in order to make it 10 characters long.
Usage:
In Power Query M, use the Text.PadEnd function with the parameters ("Name", 10).
Output:
"Name "
Add characters to the end of a text value with the "|" symbol, so it becomes 10 characters long.
Usage:
In Power Query M, use the Text.PadEnd function with the parameters ("Name", 10, "|").
Output:
"Name||||||"