Description | The |
Syntax | PAD_LEFT( |
Output | text |
Variables
text
: The original text value that you want to pad.length
: The desired total length of the resulting text after padding.character
: The character used for padding. This should be a single character.
Example
PAD_LEFT(`Column 1`, 8, "0")
Column 1 | PAD_LEFT |
42 | 00042 |
7 | 00007 |
123 | 00123 |