Difference between revisions of "RTRIM()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to remove trailing blanks
 
Function to remove trailing blanks
Line 10: Line 8:
  
 
==See Also==
 
==See Also==
[[ALLTRIM()]], [[LTRIM()]], [[STRTRAN()]], [[TRIM()]]
+
[[ALLTRIM()]], [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[PADC()]], [[PADL()]], [[PADR()]], [[RIGHT()]], [[RPAD()]], [[SET STRESCAPE]], [[STRTRAN()]], [[TRIM()]]
  
  
Line 31: Line 29:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[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 11:50, 21 July 2010

Purpose

Function to remove trailing blanks


Syntax

RTRIM(<expC>)


See Also

ALLTRIM(), LEFT(), LPAD(), LTRIM(), PADC(), PADL(), PADR(), RIGHT(), RPAD(), SET STRESCAPE, STRTRAN(), TRIM()


Description

The RTRIM() function is synonymous with the TRIM() function. This function removes trailing blank characters from the character expression <expC>. This function should be used in conjunction with the RPAD() function when used in index expressions.


Example

fname = "Christopher         "
sname = "Thompson    "
? len(fname)
        20
? len(rtrim(fname))
        11
? rtrim(fname) + " " + rtrim(sname)
Christopher Thompson


Products

Recital, Recital Server