Difference between revisions of "TRIM()"

From Recital Documentation Wiki
Jump to: navigation, search
(Products)
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
==Class==
 
String Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to remove trailing blanks
 
Function to remove trailing blanks
Line 33: 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 16:37, 8 December 2009

Purpose

Function to remove trailing blanks


Syntax

TRIM(<expC>)


See Also

ALLTRIM(), LTRIM(), RTRIM()


Description

The TRIM() function is synonymous with the RTRIM() function. It removes trailing blank characters from the character expression <expC>. This function should only be used in conjunction with the RPAD() function when used in index expressions, since index keys must be fixed length.


Example

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


Products

Recital, Recital Server