Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference FILLRIGHT
Functions and Expressions Reference Guide
108
FILLRIGHT
The FILLRIGHT function returns a text item of the length specified. The output is
filled on its right with the specified pad value.
Syntax
FILLRIGHT (single-text-expression , single-text-expression ,
single-integer-expression)
Meaning
FILLRIGHT (text_to_fill , pad_character , pad_to_length)
Returns
This function returns a single-text-item.
Returns the text string that results from padding out text_to_fill on its right
side with the pad_character up to pad_to_length characters.
Note If the pad-length argument is less than the number of characters 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
Uses
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.
Related Functions
FILLLEFT, LEAVEALPHA, LEAVEALPHANUM, LEAVENUM, LEAVEPRINT,
SQUEEZE, SUBSTITUTE, TRIMLEFT, TRIMRIGHT