Shell Programming and Scripting

This script is exactly doing the same as above scripts I posted. For example try to open the output of your script+Check.txt in wordpad and excel. Find this key AK026734
You will see the 6th column in excelfile looks like this 1,367,833 (wrong one) but in wordpad its look likes this

Code:

1367,833

(Correct one).
I would like to see the same in excel file. That is my question.

I hope you got me right

Sorry repinementer but this looks like an excel import problem. Can't help you as I don't have neither excel or wordpad at hand. Can't you choose the format for every column you import in excel? Hint: check your localisation in Windows before your import as thousand grouping character may play a role in your problem.

Oh.Thanx anyways.
One more thing is it possible to get the out put like this (Every number with comma and space) after get ridding of commas

Code:

1367, 833, someothernumber

Code:

sed 's/"\|,"//g;s/,/, /g' file

Shocking. Now every thing working perfect. may be commas need space in excel.
Thanx alot ripat. really helpful

Not sure if I got you right.
Is this what you are looking for:

Code:

sed 's/ ,/,/g; s/, /,/g; s/,$//' file

If not just post:
1. The input that you have.
2. The output that you are looking for.

Sorry, I did not realise that the issue has been resolved.
I did not see any delete option.
Please ignore this.

But your script is not removing any commas