PADC()

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

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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