CT_REPLLEFT

 REPLLEFT()
 Exchanges particular characters at the beginning of a string
------------------------------------------------------------------------------
 Syntax

     REPLLEFT(<cString>,<cReplacecharacter|
        nReplacecharacter>,[<cSearchCharacter|
        nSearchCharacter>]) --> cString

 Arguments

     <cString>  [@]  Designates the string that is processed.

     <cReplacecharacter|nReplacecharacter>  Designates the character that
     replaces the character in <cSearchCharacter|nSearchCharacter> at the
     beginning of the <cString>.

     <cSearchCharacter|nSearchCharacter>  Designates the character at the
     beginning of <cString> that is replaced by <cReplacecharacter|
     nReplacecharacter>.  The default value is a space, CHR(32).

 Returns

     The processed <cString> is returned.

 Description

     REPLLEFT() can be used to exchange all leading characters in a string
     for any other selected character.

 Note

     .  The return value of this function can be suppressed by
        implementing CSETREF() to save space in working memory.

 Examples

     .  Replace the leading spaces with zeros:

        ? REPLLEFT("  1234", "0")              // "001234"

     .  Replace the leading zeros with spaces:

        ? REPLLEFT("001234", " ", "0")         // "  1234"

     .  Replace only the leading spaces:

        ? REPLLEFT("  1    ", "0")             // "001   "

See Also: REPLALL() REPLRIGHT() CSETREF() Introduction

 

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.