>>>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
>
Yes, I realised I've spoken too soon (as always) and wanted to update my message. But since it already got a reply I have to reply with STR() back.
Anyway, it's a an exercise in my mind...
If it's not broken, fix it until it is.
My Blog