Re: Comma Delimited Files

[Arjan Hoornstra <ahoor@YAHOO.COM>]

Agree, use the 'write' command rather than several 'print' statements.
With this one can create files in any desired format... and I did :)



--- "Kuprijanow, Mike" <Mike.Kuprijanow@QWEST.COM> wrote:
> 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


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/