Harbour All Functions – A

AAdd
Abs
AChoice
AClone
ACopy
ACos

ADays
AddASCII
AddMonth
ADel
ADir
AfterAtNum
AEval
AFields
AFill
AIns
Alert
Alias
AllTrim

AMonths
Array
Asc
AScan
ASCIISum
ASCPos
ASin
ASize
ASort
At
AtAdjust
ATail
ATan
ATn2
AtNum
AtRepl
AtToken

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


Trim()

Trim()

Remove trailing spaces from a string.

Syntax

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

      ? Trim( "HELLO" )     //  "HELLO"
      ? Trim( "" )          //   ""
      ? Trim( "UA   " )     //   "UA"
      ? Trim( "   UA" )     //   "   UA"

Compliance

Clipper

Platforms

All

Files

Library is core

Seealso

RTrim(), LTrim(), AllTrim()

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

PadR()

PADR()

Right-justifies an expression for a given width

Syntax

      PADR( <xVal>, <nWidth>, <cFill> ) --> cString

Arguments

<xVal> A Number, Character or Date value to pad

<nWidth> Width of output string

<cFill> Character to fill in the string

Returns

<cString> The right-justifies string of <xVal>

Description

This function takes an date, number, or character expression <xVal> and attempt to right-justify it within a string of a given width expressed as <nWidth>. The default character used to pad right side of <xVal> will be an blank space; however, this character may be explicitly specified the value of <cFill>.

If the length of <xVal> is longer then <nWidth>, this function will truncate the string <xVal> from the leftmost side to the length of <nWidth>.

Examples

      ? PADR( "Harbour", 20 )
      ? PADR( 34.5142, 20 )
      ? PADR( Date(), 35 )

Tests

      See examples

Compliance

Clipper

Platforms

All

Files

Library is rtl

Seealso

ALLTRIM(), PADC(), PADL()

PadL()

PADL()

Left-justifies an expression for a given width

Syntax

      PADL( <xVal>, <nWidth>, <cFill> )  --> cString

Arguments

<xVal> An number, Character or date to pad

<nWidth> Width of output string

<cFill> Character to fill in the string

Returns

<cString> The left-justifies string of <xVal>

Description

This function takes an date, number, or character expression <xVal> and attempt to left-justify it within a string of a given width expressed as <nWidth>. The default character used to pad left side of <xVal> will be an blank space; however, this character may be explicitly specified the value of <cFill>.

If the length of <xVal> is longer then <nWidth>, this function will truncate the string <xVal> from the leftmost side to the length of <nWidth>.

Examples

      ? PADL( "Harbour", 20 )
      ? PADL( 34.5142, 20 )
      ? PADL( Date(), 35 )

Tests

      See examples

Compliance

Clipper

Platforms

All

Files

Library is rtl

Seealso

ALLTRIM(), PADC(), PADR()

PadC()

PADC()

Centers an expression for a given width

Syntax

      PADC( <xVal>, <nWidth>, <cFill> )  --> cString

Arguments

<xVal> A Number, Character or Date value to pad

<nWidth> Width of output string

<cFill> Character to fill in the string

Returns

<cString> The Center string of <xVal>

Description

This function takes an date, number or character expression <xVal> and attempt to center the expression within a string of a given width expressed as <nWidth>. The default character used to pad either side of <xVal> will be a blank space. This character may be explicitly specified the value of <cFill>.

If the length of <xVal> is longer then <nWidth>, this function will truncate the string <xVal> from the leftmost side to the length of <nWidth>.

Examples

      ? PADC( "Harbour", 20 )
      ? PADC( 34.5142, 20 )
      ? PADC( Date(), 35 )

Tests

      See Examples

Compliance

Clipper

Platforms

All

Files

Library is rtl

Seealso

ALLTRIM(), PADL(), PADR()