[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
COUNTLEFT()
Counts a particular character at the beginning of a string
------------------------------------------------------------------------------
Syntax
COUNTLEFT(<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 beginning
of the <cString> that is counted. The default value is a space,
CHR(32).
Returns
COUNTLEFT() returns the number of <cCharacter|nCharacter> characters
that appear in an uninterrupted sequence at the beginning of <cString>.
Description
While REMLEFT() removes leading characters from the <cString>,
COUNTLEFT() only determines the number of leading <cCharacter|
nCharacter> characters appearing in an uninterrupted sequence at the
beginning of the <cString>.
Examples
. Count the blanks:
? COUNTLEFT(" 123") // Result: 3
. Count the "." characters:
? COUNTLEFT("..4.123", ".") // Result: 2
. In this example, there is nothing to count:
? COUNTLEFT("123456") // Result: 0
See Also:
COUNTRIGHT()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson