Difference between revisions of "RPAD()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
String Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to pad out a character string to a defined length from the right
 
Function to pad out a character string to a defined length from the right
Line 8: Line 4:
  
 
==Syntax==
 
==Syntax==
RPAD(<expC1>,<expN>,[<expC2>])  
+
RPAD(<expC1>,<expN> [, <expC2>])  
  
  
 
==See Also==
 
==See Also==
[[CENTER()]], [[LPAD()]], [[PADC()]], [[PADR()]], [[STUFF()]], [[STRTRAN()]], [[STR()]], [[STRZERO()]]
+
[[CENTER()]], [[LPAD()]], [[PADC()]], [[PADL()]], [[PADR()]], [[SET STRESCAPE]], [[STR()]], [[STR_PAD()]], [[STRTRAN()]], [[STRZERO()]], [[STUFF()]]
  
  
Line 27: Line 23:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:String Data]]
 
[[Category:String Data]]
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]

Latest revision as of 15:45, 21 July 2010

Purpose

Function to pad out a character string to a defined length from the right


Syntax

RPAD(<expC1>,<expN> [, <expC2>])


See Also

CENTER(), LPAD(), PADC(), PADL(), PADR(), SET STRESCAPE, STR(), STR_PAD(), STRTRAN(), STRZERO(), STUFF()


Description

The RPAD() function left-justifies a character string <expC1> and pads out the right of the string, to a total length of <expN> characters, with blank spaces. The optional <expC2> may be used to pad <expC1> with a character string instead of blank spaces. The RPAD() function is useful for creating fixed length character strings by padding them out with blanks. If the string being processed is longer than the specified total length, it is truncated. The RPAD() function is synonymous with the PADR() function.


Example

? rpad("abc",6,"d")
abcddd


Products

Recital Server, Recital