[<<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