Difference between revisions of "ALLTRIM()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to remove leading and trailing spaces
 
Function to remove leading and trailing spaces
Line 32: Line 30:
  
 
==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]]

Revision as of 15:53, 26 November 2009

Purpose

Function to remove leading and trailing spaces


Syntax

ALLTRIM(<expC>)]]


Description

The ALLTRIM() function trims leading and trailing spaces from the character expression <expC>. This function should be used in conjunction with the RPAD() function when used in index expressions.


See Also

LPAD(), LTRIM(), RPAD(), RTRIM(), STRTRAN(), TRIM()


Example

name="   Peter   "
? len(name)
        15
? name
   Peter
? alltrim(name)
Peter
? len(alltrim(name))
         5


Products

Recital Server, Recital