Difference between revisions of "PADC()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (5 intermediate revisions by 2 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 | ||
| Line 8: | Line 4: | ||
==Syntax== | ==Syntax== | ||
| − | PADC(<expC1>,<expN>) | + | PADC(<expC1>, <expN> [, <expC2>]) |
==See Also== | ==See Also== | ||
| − | [[LPAD()]], [[PADL()]], [[PADR()]], [[RPAD()]], [[STR()]], [[STREXTRACT()]], [[STRTRAN()]], [[STRZERO()]], [[STUFF()]], [[SUBSTR()]], | + | [[CENTER()]], [[LPAD()]], [[PADL()]], [[PADR()]], [[RPAD()]], [[SET STRESCAPE]], [[STR()]], [[STREXTRACT()]], [[STRTRAN()]], [[STRZERO()]], [[STUFF()]], [[SUBSTR()]], |
==Description== | ==Description== | ||
| − | The PADC() function centers a character string <expC1> and pads out the right and left of the string, to a total length of <expN> characters with blanks. PADC() returns the new string. If the string being processed is longer than the specified total length, it is returned unchanged. | + | The PADC() function centers a character string <expC1> and pads out the right and left of the string, to a total length of <expN> characters with blanks. The optional <expC2> may be used to pad <expC1> with a character string instead of blank spaces. PADC() returns the new string. If the string being processed is longer than the specified total length, it is returned unchanged. |
| Line 27: | Line 23: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:String Data]] | ||
| + | [[Category:String Data Functions]] | ||
Latest revision as of 15:44, 21 July 2010
Purpose
Function to pad out a string to a specified length
Syntax
PADC(<expC1>, <expN> [, <expC2>])
See Also
CENTER(), LPAD(), PADL(), PADR(), RPAD(), SET STRESCAPE, STR(), STREXTRACT(), STRTRAN(), STRZERO(), STUFF(), SUBSTR(),
Description
The PADC() function centers a character string <expC1> and pads out the right and left of the string, to a total length of <expN> characters with blanks. The optional <expC2> may be used to pad <expC1> with a character string instead of blank spaces. PADC() returns the new string. If the string being processed is longer than the specified total length, it is returned unchanged.
Example
? ["] + padc("abc",7) + ["] " abc "
Products
Recital, Recital Server
