FILLRIGHT

The FILLRIGHT function returns a text item of the length specified. In the output, the text item is appended with the specified pad value.

You can use FILLRIGHT when you have a value that needs to be of a fixed size with a variable number of trailing characters of a specified value.

Syntax:
FILLRIGHT (single-text-expression , single-text-expression , single-integer-expression)
Meaning:
FILLRIGHT (text_to_fill , pad_character , pad_to_length)
Returns:
A single text item

FILLRIGHT returns the text string that results from padding out text_to_fill by appending the pad_character up to pad_to_length bytes.

If the pad-length argument is less than the number of bytes in the text to fill, no padding will appear.

Examples

  • FILLRIGHT (LastName:Contact, " " , 25)

    If LastName has the value Peterson, FILLRIGHT returns Peterson followed by 17 spaces.

Related functions

  • FILLLEFT
  • LEAVEALPHA
  • LEAVEALPHANUM
  • LEAVENUM
  • LEAVEPRINT
  • SQUEEZE
  • SUBSTITUTE
  • TRIMLEFT
  • TRIMRIGHT