UNIX for Dummies Questions & Answers

I need to ask a question on how to format the output in a csv format. Right now i am running a shell script which executes a command and the following output is append through a unix script in a .csv file.

So the output of xyz.csv is as follow :-

Code:

1. Number = 25 Amount $84,132.22
2. Number = 26 Amount $1.02
3. Number = 92 Amount $0.00
4. Number = 85 Amount $24,618.59
.
.
.

Now if i view it in excel the output is all messed up. The headers are printed in one column and the values are also printed in one column except for decimal values which are printed in the second column.

How can i make it allign perfectly to view it in the CSV file which is formatted?

1st you have to tell which fields/columns should be used, like for example using the semicolon as delimiter:

Code:

1.;Number = 25;Amount $84,132.22
2.;Number = 26;Amount $1.02
3.;Number = 92;Amount $0.00
4.;Number = 85;Amount $24,618.59

Then someone here in the forum would be able to write a short awk/sed line to make your file a csv-File. What you showed is no csv file, it's just some lines where nothing is really separated by an unique delimeter.
When you got a delimeter then ie. a "real" csv-File, you can import it to Excel and the columns will be recognized by defining the right delimeter.