[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
COUNTRIGHT()
Counts a particular character at the end of a string
------------------------------------------------------------------------------
Syntax
COUNTRIGHT(<cString>,[<cCharacter|nCharacter>]) --> nNumber
Arguments
<cString> Designates the character string in which the
<cCharacter|nCharacter> character is counted.
<cCharacter|nCharacter> Designates the character at the end of the
<cString> that is counted. The default value is a space, CHR(32).
Returns
COUNTRIGHT() returns the number of <cCharacter|nCharacter> characters
that appear in an uninterrupted sequence at the end of the <cString>.
Description
While REMRIGHT() removes trailing characters from the <cString>,
COUNTRIGHT() only determines the number of trailing <cCharacter|
nCharacter> characters appearing in an uninterrupted sequence at the end
of the <cString>.
Examples
. Count the blanks:
? COUNTRIGHT("abc ") // Result: 3
. Count the "." characters:
? COUNTRIGHT("abc.d..", ".") // Result: 2
. In this example, there are no spaces to count:
? COUNTRIGHT("123456") // Result: 0
See Also: COUNTLEFT()
Online resources provided by: http://www.ClipX.Net --- NG 2 HTML conversion by Dave Pearson