fbpx
Select Page

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

Usage

RPad (<text>, <length>, <fill>)

text (required): The string to pad 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.

Examples

RPad(“sigma”, 10, “-“)
  • Returns “sigma—–“
Rpad(“Sigma Computing”, 10)
  • Returns “Sigma Comp”

See Also

LPad

More About Text Functions

Text functions analyze or manipulate string data and are useful sanitizing string input.

When inputting a string, use quotation marks to indicate it as a string. “This is read as a string”

If you would like to include quotes in your string, you can use a slash \ to indicate the following quote is part of the string. “\”This is a string with quotes\”” will display as “This is a string with quotes”

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.