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


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.


LPad(\[Product Family\], 4)

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

LPad("sigma", 10, "-")

  • Returns "-----sigma"

LPad("Sigma Computing", 10)

  • Returns "Sigma Comp"

Related resources