PADR,L,C ​
Returns the specified expression padded on the right, left, or both sides.
Reporting Area(s) ​
General
Required Parameters ​
- Field Name
--OR-- Character expression to be padded (i.e. coaccount, "Account #😊
- Numeric value: number of characters to pad expression (i.e. 20 pads the expression to 20
- 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