LPad

Prepends a pattern to or truncates a string to the desired length.

Usage

LPad(text, length, [fill])

text (required)- The string, or column of strings, to pad or trim to the desired length.

length (required)- The length of the returned string.

fill (optional)- The character with which to pad the text. Defaults to space.

Example

LPad([Product Family], 4)

• Returns the Product Family column trimmed to a length of 4

LPad("Space", 10, "-")

• Returns "-----space"

LPad("Analytics Pro", 10)

• Returns "Analytics "