Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference FILLLEFT
Functions and Expressions Reference Guide
107
FILLLEFT
The FILLLEFT function returns a text item of the length specified. The output is
filled on its left with the specified pad value.
Syntax
FILLLEFT (single-text-expression , single-text-expression ,
single-integer-expression )
Meaning
FILLLEFT (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 left 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
FILLLEFT ( AcctID:Transaction , "0" , 5 )
If AcctID has the value 14, FILLLEFT returns 00014
FILLLEFT ( NUMBERTOTEXT ( InvoiceAmt ) , "*" , 10 )
If InvoiceAmt has the value 24.75, FILLLEFT returns *****24.75
Uses
Use
FILLLEFT when you have a value that needs to be of a fixed size with a
variable number of leading characters with a specified value.
Related Functions
FILLRIGHT, LEAVEALPHA, LEAVEALPHANUM, LEAVENUM, LEAVEPRINT,
SQUEEZE, SUBSTITUTE, TRIMLEFT, TRIMRIGHT