Re: HOWDOI: Output Variable Length Fields

Hayden Worthington, Inc. wrote:
>
> Eric M. Gamble wrote:
> >
> > I just tried this method with NO success... Has anyone outputted a
> > delimted file? If so, how?...
> >
>
> Going to a comma delimited file is really easy. I'm not sure what kind
> of problems you're having but this little script here works fine!
>
> Give a shot!
>
> set heading off
> set trimspool on
> spool junk.lst
> select rtrim(col1)||','||rtrim(col2)||','||rtrim(col3) from table;
> spool off;

What if you have to set linesize to 120 for example. How do you truncate the spaces at the end of the line to make each record variable length??? Received on Fri Jan 24 1997 - 00:00:00 CET