Difference between revisions of "RTRIM()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to remove trailing blanks | Function to remove trailing blanks | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[ALLTRIM()]], [[LTRIM()]], [[STRTRAN()]], [[TRIM()]] | + | [[ALLTRIM()]], [[LEFT()]], [[LPAD()]], [[LTRIM()]], [[PADC()]], [[PADL()]], [[PADR()]], [[RIGHT()]], [[RPAD()]], [[SET STRESCAPE]], [[STRTRAN()]], [[TRIM()]] |
| Line 33: | Line 29: | ||
==Products== | ==Products== | ||
| − | Recital | + | 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
