Difference between revisions of "PADL()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 4: | Line 4: | ||
==Syntax== | ==Syntax== | ||
| − | PADL(<expC1>,<expN>,<expC2>) | + | PADL(<expC1>, <expN> [, <expC2>]) |
| Line 13: | Line 13: | ||
==Description== | ==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. | 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. | ||
| + | |||
| + | The PADL() function is synonymous with the LPAD() function. | ||
Latest revision as of 15:43, 21 July 2010
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.
The PADL() function is synonymous with the LPAD() function.
Example
? padl("abc",6,"X") XXXabc
Products
Recital, Recital Server
