topic Re: append the output to a .csv format in Operating System - HP-UX

append the output to a .csv format

shikhar_1 — Fri, 20 May 2011 02:12:15 GMT

Hello,

I got stuck while appending the output of command in .csv format at a aprticular column in my .csv file.
Actually i need to create a report for that i have already created the shell script and its output is coming in number suppose "32" and i have to put this number in a excel sheet to a particular location.
Pls help me.

Reagrds,

Shikhar Verma

Re: append the output to a .csv format

Steven Schweda — Fri, 20 May 2011 02:27:11 GMT

> Pls help me.

You first. We non-psychics can't see any of
your data, and some of us can't guess what
you wish to do.

What do you have now?

What would you like to get?

Actual examples would probably be more useful
than vague descriptions.

Where are you trying to do this?

uname -a

Re: append the output to a .csv format

shikhar_1 — Fri, 20 May 2011 02:38:54 GMT

Hi,

I am doing it on HP-UX server. My current script is giving me the output which i need to put it in a particular column of excel sheet.

./myscript this script is giving me some o/p
and i wanted to put this o/p in my report file, which is excel file.

Re: append the output to a .csv format

shikhar_1 — Fri, 20 May 2011 02:45:16 GMT

Hi,

My query is that ---
is it possible to redirect the o/p of any shell script to a excel sheet to a particular couln or row?

Re: append the output to a .csv format

shikhar_1 — Fri, 20 May 2011 02:54:27 GMT

Say my text file data is:

15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009

say my first excel column is:

column1 column2 column3
server1
server2

I want output as below:

column1 | column2 | column3
server1 | 15-dec-2008 | 15-dec-2009
server2 | 16-dec-2008 | 16-dec-2009

Re: append the output to a .csv format

Hein van den Heuvel — Fri, 20 May 2011 03:25:49 GMT

Ok Shikar,

you are getting closer to a proper explanation.
IF this exactly describes the problem you can solve it like so:

$ cat > text.txt
15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009
$ cat > excel.csv
column1 column2 column3
server1
server2
$ awk 'BEGIN { print } 1' text.txt | paste -d' ' excel.csv - | sed 's/ / | /g'
column1 | column2 | column3 |
server1 | 15-dec-2008 | 15-dec-2009
server2 | 16-dec-2008 | 16-dec-2009

First we use AWK to feed a pipe with a blank line and the contents of the text file.
That gets patsted with the excel file using a space, not the default tab, as seperator.
Finally replace each space with a spaced-bar/pipe

I doubt that this will solve the problem though.

You really want to know more about the data. Like whether you know for sure each line is in the right order.
Maybe there is a 'key' column perhaps 'system same' and we should use JOIN, not PASTE

Maybe you should really take a huge step back and revisit how the data comes to be.
Whether the column headers are meaningful and that meanig can be used.
Whether column headers are hardcoded or should/could be generated.
Whether the lines just have order, or have a 'tag'/'key'.

Good luck!
Hein