Hi,
I am writing a unix script through which I want to run a sql query and stores it's output in xls file.
I tried to create csv file (through spooling)but this is having a problem b'coz one of my field is having comma in itself.so if i'll make colsep as comma it will also break my field in to two parts.Thats why I want to create a xls file directly.I am using sqlplus command in my unix script.
Please help me out

Hi vinita24,

you can create csv file like this , put double quote around your data. It will not break.

"AAA,AAA","21,21","BBBBBB"

hope this works.



Regards
Bishnu Pokharel
[email protected]
http://www.bishnupokharel.com.np/

you also might want to check out some Perl stuff some people wrote, with perl scripts allows you to write directly to an xls file.