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("sigma", 10, "-")
  • Returns "-----sigma"
LPad("Sigma Computing", 10)
  • Returns "Sigma Comp"

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us