Re: Comma Delimited Files

["Kuprijanow, Mike" <Mike.Kuprijanow@QWEST.COM>]

I just write to a file named "filename.csv" with a comma in between each
field.

write 2 from
     $emplid
        ','
        $empl_status
        ','
        $deptid



-----Original Message-----
From: Tim Wilkinson [mailto:Tim.Wilkinson@HANCORP.CO.UK]
Sent: Thursday, May 10, 2001 11:40 AM
To: SQR-USERS@list.iex.net
Subject: Comma Delimited Files


Hi all,
       I've now gone from a newbie novice to 42 SQR reports under my belt,
(well 41.75 if my boss read this ;) ) and now they are asking for one to be
output to .csv format!

Now I understand that this requires a command line flag to output to .csv
(-EH_CSV). However, what I would like to know before I kill myself
formatting and looking up how to output in tiny fonts (as its a lot of data
for one line) is does all this information have to be on one line (below a
header) as I suspect or can it be on numerous lines and if so, what are the
implications of this.

I know that with a couple of hours trial and effort I can find all this out
myself, but I would be obliged if someone who has gone through this would
enlighten me and save me a couple of hours of trial and error (I have to get
this particular report out yesterday as per usual). Any hints/tips gleaned
by battle-hardened pros would be appreciated as well.

Once again I feel like the crew of NCC-1701, boldly going where no sane
person has gone before :-)

Thanks in advance,
                  Tim


Tim Wilkinson BSc. Dip Comp.
Analyst Programmer
Hansen Corporation Europe Ltd

Email:  Tim.Wilkinson@hancorp.co.uk
Phone:  01904 566017