Convert sql output to csv file via bash tools


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convert sql output to csv file via bash tools
# 1  
Old 07-05-2011
Convert sql output to csv file via bash tools

hi

Can anybody help me with converting such structure into csv file for windows :

Code:
BAT_ID       ID_num   CVS_LINE                A_SEG     SKILL_TO         A_CUSTOMER_TYPE
--------- ---------- --------------------------------- ---------- ------------------ ----------- 
14-MAY-11   777752   trw@aol.us                         3        write               35235

I need to convert it in solaris (bash tools tr or awk or sed ) and it will be opened in windows

thanks

thnaks

Last edited by pludi; 07-05-2011 at 09:08 AM..
# 2  
Old 07-05-2011
Code:
tr ' ' ';' <input

Code:
[ctsgnb@shell ~/sand]$ cat tst2
BAT_ID ID_num CVS_LINE A_SEG SKILL_TO A_CUSTOMER_TYPE
--------- ---------- --------------------------------- ---------- ------------------ -----------
14-MAY-11 777752 trw@aol.us 3 write 35235
[ctsgnb@shell ~/sand]$ tr ' ' ';' <tst2
BAT_ID;ID_num;CVS_LINE;A_SEG;SKILL_TO;A_CUSTOMER_TYPE
---------;----------;---------------------------------;----------;------------------;-----------
14-MAY-11;777752;trw@aol.us;3;write;35235
[ctsgnb@shell ~/sand]$

# 3  
Old 07-05-2011
and how to convert to windows format ?
# 4  
Old 07-05-2011
What do you mean by windows format?
If you are talking of CRLF, since you didnt mention the OS you use you would have to see if you have a ux2dos or unix2dos utility installed...
# 5  
Old 07-05-2011
yes exactly I mean CRLF, bu the problem is that I cant install above mentioned utilities

---------- Post updated at 08:52 AM ---------- Previous update was at 08:50 AM ----------

Quote:
Originally Posted by ctsgnb
Code:
tr ' ' ';' <input

Code:
[ctsgnb@shell ~/sand]$ cat tst2
BAT_ID ID_num CVS_LINE A_SEG SKILL_TO A_CUSTOMER_TYPE
--------- ---------- --------------------------------- ---------- ------------------ -----------
14-MAY-11 777752 trw@aol.us 3 write 35235
[ctsgnb@shell ~/sand]$ tr ' ' ';' <tst2
BAT_ID;ID_num;CVS_LINE;A_SEG;SKILL_TO;A_CUSTOMER_TYPE
---------;----------;---------------------------------;----------;------------------;-----------
14-MAY-11;777752;trw@aol.us;3;write;35235
[ctsgnb@shell ~/sand]$

its o but when I have there structure like
kkkk
it converts to
,,,, kkkk

and that is not required
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Not able to write SQL query output in to .csv file with shell script.

I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line. Main Code shell script: this is my code: #!/bin/bash file="db_detail.txt" . $file rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies

2. Shell Programming and Scripting

Convert sql file to csv file

How to convert name.sql file into name.csv file. Basically my input source file is .sql file, I need to verify data after the import of that exported sql file. Thanks for any help. (3 Replies)
Discussion started by: wamqemail2
3 Replies

3. Shell Programming and Scripting

SQL query output convert to HTML & send as email body

Hi , I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body. p_id src_system amount 1 A 100 2 B 200 3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies

4. Shell Programming and Scripting

Read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (25 Replies)
Discussion started by: Ram.Math
25 Replies

5. Shell Programming and Scripting

to read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (1 Reply)
Discussion started by: Ram.Math
1 Replies

6. Shell Programming and Scripting

formatting into CSV format of SQL session output

I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format . The output should be like this 'a','b','c', (4 Replies)
Discussion started by: mady135
4 Replies

7. Shell Programming and Scripting

SQL Script's output to a CSV file

I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ? I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I... (4 Replies)
Discussion started by: Sriranga
4 Replies

8. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

9. Shell Programming and Scripting

script to convert CSV to SQL

I am trying to write a script to convert csv files into SQL format. What I am missing is: 1. handling of the first row and create it as a insert into format 2. better handling of any other row, and create a line with the data. *The while read line needs a better work. I thought of using awk. ... (1 Reply)
Discussion started by: saariko
1 Replies
Login or Register to Ask a Question