Page 1 of 1

PADR and LEN

Posted: Fri Feb 10, 2006 9:55 am
by deanomeano
In my program I have a comments field, which, if empty, will save the filename used and place .rpt extension onto the filename. However, although the majority of these work, a few of them will show the filename with a large gap before the .rpt extension. how can I solve this?

EXAMPLE ;

[Monthly Account Invoice Proof .rpt]

The above should be displayed as

[Monthly Account Invoice Proof.rpt]

Here is the code used;

IF !Empty(cApp)
IF mFile == 1
mReportID := Alltrim(cApp)+".rpt"
mReportName := PADR(cApp,LEN(REPDETS->REP_NAME))
mRepComm := ("["+PADR(cApp,len(REPDETS->REP_NAME))+".rpt]")
RepIdValid()

Posted: Fri Feb 10, 2006 11:25 am
by deanomeano
I tried using Alltrim instead of PADR on the
mRepComm := ("["+PADR(cApp,len(REPDETS->REP_NAME))+".rpt]") line, which seemed to fix a few of the records. although some still had a large gasp before the .rpt extension, with some records not even showing .rpt extension. am I doing something wrong or could this be a bug?

Many Thanks

Posted: Fri Feb 10, 2006 7:05 pm
by James Bott
I don't understand why you are using PADR(). This will put trailing spaces onto your filename, which is what you don't want. Use rtrim() instead.

James