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