Hi,
Can anyone help me out on this?
I have a sybase stored procedure (say x), when I write isql to execute this procedure within the script, it generates output and put in a .txt file as I have mentioned.
I want to know two things here:
1.) How I can convert this .txt file in .csv format (Please give me elaborated details step by step as I am new to scripting)
2.) How I can ftp this file from one server to another through the same unix script.
Please reply urgently.
Thanks
---------- Post updated at 09:51 AM ---------- Previous update was at 09:49 AM ----------
For fpmurphy: I had tried to direct it to .csv but the same format of .txt appears in the .csv as well. The data is not saparated by different cells.
Please see my above post for more clarification.
Thanks