>>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
>
>VFP is smarter than you think!
>LIST off job_nbr,' ',price,' ',old_price,' ',todaydt for g>1
Actually, if you are OK with a single instead of triple space between columns:
LIST off job_nbr, price, old_price, todaydt for g>1
That is, a comma in the command (not "," in the ",nd" :) gives you one space, and that's when you have Set Heading Off. With headings, your columns will be at least wide enough to accomodate the column widths, plus one space between.