Harbour All Functions – T

TabExpand
TabPack

Tan

TanH

TBrowseDB

TBrowseNew

TFileRead

THtml

Time

TimeValid

TNortonGuide 

Token
TokenAt
TokenEnd
TokenExit
TokenInit
TokenLower
TokenNext
TokenNum
TokenSep
TokenUpper

Tone

TOs2

Transform
Trim

TRtf

TTroff

 Type

String Functions

AddASCII

AfterAtNum

AllTrim
Asc

ASCIISum

ASCPos
At

AtAdjust

AtNum
AtRepl
AtToken

BeforAtNum

Chr

CharAdd
CharAnd
CharEven
CharHist
CharList
CharMirr
CharMix
CharNoList
CharNot
CharOdd
CharOne
CharOnly
CharOr
CharPix
CharRela
CharRelRep
CharRem
CharRepl
CharRLL
CharRLR
CharSHL
CharSHR
CharSList
CharSort
CharSub
CharSwap
CharWin
CharXOR

CountLeft
CountRight
Descend
Empty
hb_At
hb_RAt
hb_ValToStr
IsAlpha
IsDigit
IsLower
IsUpper

JustLeft
JustRight

Left
Len
Lower
LTrim

NumAt
NumToken
PadLeft
PadRight

PadC
PadL
PadR

POSALPHA
POSCHAR
POSDEL
POSDIFF
POSEQUAL
POSINS
POSLOWER
POSRANGE
POSREPL
POSUPPER

RangeRem
RangeRepl

RAt

RemAll

RemLeft
RemRight
ReplAll

Replicate

ReplLeft

ReplRight

RestToken

Right
RTrim

SaveToken

SetAtLike
Space
Str

StrDiff

StrFormat

StrSwap

StrTran
StrZero
SubStr

TabExpand
TabPack

Token

TokenAt
TokenEnd
TokenExit
TokenInit
TokenLower
TokenNext
TokenNum
TokenSep
TokenUpper

Transform
Trim
Upper
Val

ValPos
WordOne
WordOnly
WordRem
WordRepl
WordSwap

WordToChar


RTrim()

RTRIM()

Remove trailing spaces from a string.

Syntax

      RTRIM( <cExpression> ) --> cString

Arguments

<cExpression> Any character expression

Returns

<cString> A formatted string with out any blank spaced.

Description

This function returns the value of <cString> with any trailing blank removed.

This function is identical to RTRIM() and the opposite of LTRIM(). Together with LTRIM(), this function equated to the ALLTRIM() function.

Note : Characters with ASCII code 9, 10 and 13 always treated as “white spaces”.

Examples

      ? RTRIM( "HELLO" )              //  "HELLO"
      ? RTRIM( "" )                   //  ""
      ? RTRIM( "UA   " )              //  "UA"
      ? RTRIM( "   UA" )              //  "   UA"

Tests

      See Examples

Compliance

Clipper

Platforms

All

Files

Library is rtl

Seealso

ALLTRIM(), LTRIM(), TRIM()

LTrim()

LTRIM()

Removes leading spaces from a string

Syntax

      LTRIM( <cString> ) --> cReturn

Arguments

<cString> Character expression with leading spaces

Returns

LTRIM() returns a copy of the original string with leading spaces removed.

Description

This function trims the leading space blank

Note : Characters with ASCII code 9, 10 and 13 always treated as “white spaces”.

Examples

      ? LTRIM( "HELLO     " )

Compliance

Clipper

Platforms

All

Files

Library is rtl

Seealso

TRIM(), RTRIM(), ALLTRIM()

AllTrim()

ALLTRIM()

Removes leading and trailing blank spaces from a string

Syntax

      ALLTRIM( <cString> ) --> cExpression

Arguments

<cString> Any character string

Returns

<cExpression> An string will all blank spaces removed from <cString>

Description

This function returns the string <cExpression> will all leading and trailing blank spaces removed.

Note : Characters with ASCII code 9, 10 and 13 always treated as “white spaces”.

Examples

      ? ALLTRIM( "HELLO HARBOUR" )
      ? ALLTRIM( "     HELLO HARBOUR" )
      ? ALLTRIM( "HELLO HARBOUR     " )
      ? ALLTRIM( "     HELLO HARBOUR     " )

Compliance

Clipper

Platforms

All

Files

Library is rtl

Seealso

LTRIM(), RTRIM(), TRIM()

C5_TRIM

 TRIM()
 Remove trailing spaces from a character string
------------------------------------------------------------------------------
 Syntax

     TRIM(<cString>) --> cTrimString

 Arguments

     <cString> is the character string to be copied without trailing
     spaces.

 Returns

     TRIM() returns a copy of <cString> with the trailing spaces removed.  If
     <cString> is a null string ("") or all spaces, TRIM() returns a null
     string ("").

 Description

     TRIM() is a character function that formats character strings.  It is
     useful when you want to delete trailing spaces while concatenating
     strings.  This is typically the case with database fields which are
     stored in fixed-width format.  For example, you can use TRIM() to
     concatenate first and last name fields to form a name string.

     TRIM() is related to LTRIM(), which removes leading spaces, and
     ALLTRIM(), which removes both leading and trailing spaces.  The inverse
     of ALLTRIM(), LTRIM(), and RTRIM() are the PADC(), PADR(), and PADL()
     functions which center, right-justify, or left-justify character strings
     by padding them with fill characters.

 Notes

     .  Space characters:  The TRIM() function treats carriage
        returns, line feeds, and tabs as space characters and removes these
        as well.

 Examples

     .  This is a user-defined function in which TRIM() formats city,
        state, and zip code fields for labels or form letters:

        FUNCTION CityState(cCity, cState, cZip)
           RETURN TRIM(cCity) + ", " ;
            + TRIM(cState) + "  " + cZip

     .  In this example the user-defined function, CityState(),
        displays a record from Customer.dbf:

        USE Customer INDEX CustName NEW
        SEEK "Kate"

        ? CityState(City, State, ZipCode)
        // Result: Athens, GA 10066

 Files   Library is CLIPPER.LIB.

See Also: PAD() RTRIM() SUBSTR()



Strong Relation

Build strong relationships

Basics of building databases, indexs and relations.