PADL

Syntax

PADL (text_string, width, pad_character)

Description

Returns string, padded on the left with the pad_character or spaces.

Arguments

text_string	String to pad.
width	Number of characters in total that should be returned as a combination of the text_string and the padding.
pad_character	Optional character used for padding. If not specified, spaces are used.

Returns

Returns a string padded on the left with the character used in the pad_character argument. If the pad_character is not specified, spaces are used.

Remarks

If the width is less than the length of the input string, then the input string is returned, not truncated. To truncate use the LEFT or RIGHT functions.

Examples

PADL("Name", 10)

Returns:

PADL("Name", 2)