Difference between revisions of "PADL()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
(3 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to pad out a string to a specified length | Function to pad out a string to a specified length | ||
− | |||
==Syntax== | ==Syntax== | ||
PADL(<expC1>, <expN> [, <expC2>]) | PADL(<expC1>, <expN> [, <expC2>]) | ||
− | |||
==See Also== | ==See Also== | ||
[[CENTER()]], [[LPAD()]], [[PADC()]], [[PADR()]], [[RPAD()]], [[SET STRESCAPE]], [[STR()]], [[STREXTRACT()]], [[STRTRAN()]], [[STRZERO()]], [[STUFF()]], [[SUBSTR()]], | [[CENTER()]], [[LPAD()]], [[PADC()]], [[PADR()]], [[RPAD()]], [[SET STRESCAPE]], [[STR()]], [[STREXTRACT()]], [[STRTRAN()]], [[STRZERO()]], [[STUFF()]], [[SUBSTR()]], | ||
− | |||
==Description== | ==Description== | ||
Line 15: | Line 12: | ||
The PADL() function is synonymous with the LPAD() function. | The PADL() function is synonymous with the LPAD() function. | ||
− | |||
==Example== | ==Example== | ||
Line 22: | Line 18: | ||
XXXabc | XXXabc | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== | ||
− | + | Lianja, Lianja Server | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] |
Latest revision as of 06:42, 4 February 2013
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
Lianja, Lianja Server