PADL()

From Recital Documentation Wiki
Revision as of 11:52, 21 July 2010 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Purpose

Function to pad out a string to a specified length


Syntax

PADL(<expC1>,<expN>,<expC2>)


See Also

CENTER(), LPAD(), PADC(), PADR(), RPAD(), SET STRESCAPE, STR(), STREXTRACT(), STRTRAN(), STRZERO(), STUFF(), SUBSTR(),


Description

The PADL() function right justifies a character string <expC1> and pads out the left of the string, to a total length of <expN> characters. PADL() returns the new string. If <expC2> is not specified, <expC1> will be padded with blanks, otherwise the string will be padded with the character specified by <expC2>. If the string being processed is longer than the specified total length, it is truncated.


Example

? padl("abc",6,"X")
XXXabc


Products

Recital, Recital Server