Shell Programming and Scripting

Not a good piece of advice. The 5th column might also have spaces. Also, the counts will mostly be preceded by spaces.

Actually you know what once I create this file from Linux then using Java I am reading that created excel/csv file and it is failing there.
Exception is "Unable to read entire header". And what I have seen the csv file created through linux is proper. But if I try to create a excel file the values are not appearing in different column , in this case I do not even need ',' as a delimiter.

So can someone tell me how do I create excel file from that grep command so that output goes into different column per row instead of one column per row?

Just a suspicion: when you transfer the file from Unix/Linux to Windows to pick it up with Excel, do you adjust the line endings? If not, then Excel probably might be confused ...

Check it with notepad: after transferring the file open it with notepad and if it looks like a regular text file, everything is OK. If everything appears to be on one very long line with funny characters instead of the line feeds then retransmit the file using "ascii" as the FTP mode instead of "binary".

I hope this helps.

bakunin

Hi bakunin,

Thank you for the reply. But I do not think there is any encoding issue. Everything looks great.
The issue is the values are appearing in one column(with , delimited) instead of different column (with no comma).

Desired Excel Output:-

Column1 Column2
Count Field

222 Field5
10 Field5


Thanks,
Kousik

When importing to EXCEL, you can select which chars be the separators. Are you sure you are using "," there?

Yes. I am.
And also other excel files are looking fine except those I create from linux by those grep commands.

Could you please provide meaningful samples of the output of the various stages of your pipeline? Seems like there is something rotten in the state of Denmark.

This was your initial pipe:

Code:

grep -e cmd -e cmd1 test.txt | cut -f 5 | sort | uniq -c> op.csv

Now do the following:

Code:

grep -e cmd -e cmd1 test.txt > intermediate1.out
grep -e cmd -e cmd1 test.txt | cut -f 5 > intermediate2.out
grep -e cmd -e cmd1 test.txt | cut -f 5 | sort > intermediate3.out
grep -e cmd -e cmd1 test.txt | cut -f 5 | sort | uniq -c > op.csv

and post a meaningful part of each of these files, ideally from each the part which deals with the same data.

It might help in finding a solution to see what happens to the data in the various steps. Somehow i believe it might not be what you expect it to be.

I hope this helps.

bakunin