CT_COUNTLEFT

 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()



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.