LPAD

Inserts characters you specify to the left-side of a text string.

Use

LPAD(text, padded_length[, pad_string]) and replace the variables:

text is the field or expression you want to insert characters to the left of.
padded_length is the number of total characters in the text that’s returned.
pad_string is the character or characters that are inserted. pad_string is optional and defaults to a blank space.

If the value in text is longer than pad_string, text is truncated to the size of padded_length.

Leading blank spaces and zeros are omitted.

Field Name Example: Padding

LPAD(Name, 20) truncates the Name field after 20 characters. For example, if the name is mycompany.com, the value returned is "mycompany.com."

My Company Example: No Change

LPAD('my_company.com', 14, 'z') returns “my_company.com” without change because it has 14 characters.

Field Name Example: Padded with Z

LPAD(Name, 15, 'z') returns the name “zmycompany.com.”

Field Name Example: Truncating Ex

LPAD(Name, 2) truncates the name after the second character. For example, if the name is mycompany.com, the value returned is “my.”

Did this article solve your issue?

Let us know so we can improve!