>>Hi, I have outputted some data to a file for use in a report but the price figure do not align properly and want to know a work around.
>>LIST off job_nbr,' ',ALLTRIM(STR(price,10,2)),' ',ALLTRIM(STR(old_price,10,2)),' ',todaydt for g>1
>>but ends up looking like this depending on length of price value.
>>
>>13T001 7.00 6.00 09/15/08
>>14T001 137.00 6.00 09/15/08
>>15T001 9.00 6.00 09/15/08
>>16T001 2.00 6.00 09/15/08
>
>Well, you just need to use PADR function instead of ALLTRIM(STR( to padr to the number of chars your want and align properly.
>
>LIST off job_nbr,' ',PADR(price,10),' ',PADR(old_price,10,),' ',todaydt for g>1
padr() ?
LIST off job_nbr,' ',STR(price,10,2), ' ',STR(old_price,10,2), ' ',todaydt for g>1
Gregory