Shell Programming and Scripting

Hi,

I am facing issues while exporting the results retrieved from the Database to an excel file.

I have 5 count query in order to count the records in 5 different tables.

I had connected to the DB and retrieved the column count and printed in the screen.

But wat I need to do is, I have to export the count results to an excel sheet which should be saved in my local system.
The format of the output should be:
Column1 Column2
AAAA 10
BBBB 12
CCCC 100

I searched in other threads and it was given as to export all these to a csv file first and then to excel file. I have also exported to csv file but the o/p is not formatted.

It is like AAAA 10 BBBB 12 CCCC 100

Please help!!!

How are you printing the results out?
Can you please paste the code you are using?

--ahamed

Run the output through xargs first:

Code:

$ echo "AAAA 10 BBBB 12 CCCC 100" | xargs -n2
AAAA 10
BBBB 12
CCCC 100

Code:

$ echo "AAAA 10 BBBB 12 CCCC 100" | xargs -n2 | tr ' ' ,
AAAA,10
BBBB,12
CCCC,100

Here is my coding:

export ORACLE_SID=ABCD
result=`sqlplus -s /NOLOG << EOF
connect username/pass
SELECT count(*) from A;
`
The same way, am collectng all the 5 query's results in 5 different variables and finally printing on the screen using the print statement. Till this it works perfectly..
result_set=`printf "A: %d\n" $result
printf "B: %d\n" $result1
printf "C %d\n" $result2
printf "D: %d\n" $result3
printf "E: %d\n" $result4
`
Now am collectng altogether in result_set (which I think is unwanted) and then exporting this to csv file.
echo $result_set > results.csv

here it prints everythng in a single line...

Try -e with echo

Code:

echo -e $result_set > results.csv

--ahamed

Try:

Code:

echo "$result_set" > results.csv

-or-

Code:

printf "%s\n" "$result_set" > results.csv

Thanks Scrutinizer & ahamed101,

Both (i)printf "%s\n" "$result_set" > results.csv
(ii) echo "$result_set" > results.csv

is working fine..

Now the output is formatted in the csv file...

Now I need the same to be exported in to an excel file which should be saved in the local PC..

Please give me some idea on that as I am unable to get it from any of the threads...