Hi,
Thanks for all your replies.
I actually run the sql statement inside the script and it fetches three columns from DB. And it comes likes this.
AAAA BBBBBBB [BBB] CCCCC
AAAA BBBBBBBBB [BBBB] CCCC
I am also inserting the heading for this three coulmns through an echo command. But when i open the csv file all are under column A.
@YGOR - How can I tab the columns that is being taken from the DB through an SQL command.
@
michaelrozar17 - I just ask this because I am calling the SQL only from a shell script and just want to know is there a way to format these text with the headings to appear in a proper way?
@
xoops - I can check that, but I am sending the file directly from my script in the email. So i doubt that will work.
Let me know if this can be achieved by sed or awk?
Regards,
RR
---------- Post updated at 10:26 AM ---------- Previous update was at 08:42 AM ----------
Guys,
Nevermid. I figured it out and it works fine now. Thanks all for your help.