PADR,L,C

Returns the specified expression padded on the right, left, or both sides.

Reporting Area(s)

General

Required Parameters

1. Field Name

--OR-- Character expression to be padded (i.e. coaccount, "Account #😊

2. Numeric value: number of characters to pad expression (i.e. 20 pads the expression to 20
3. Character to pad expression with (i.e. " ", "-")

Optional Parameters

None

Example(s)

PADR(coaccount,20," ") pads the course account number with spaces to 20 characters (i.e. 21-100021)

PADL(coaccount,20," ") pads the course account number with spaces to 20 characters (i.e. 21-100021)

PADC(coaccount,20,"-") pads the course account with hyphens to 20 characters on both sides (i.e. -----21-100021-----)

Notes

Standard FoxPro Function

Related Functions

TRIM