Excel file attachment showing data in single column

Shell Programming and Scripting
1

Hi All, found similar posts, but not exatcly what i wanted.

I have an text file like below and am trying to send mail as an excel file but when i get the excel file as the attachment, all the data is coming in the first column. I need below data in 4 columns.

Unix file

Name,ID,Trade,Date
DY37,2,19337,20120523

am getting excel file as below

 Name,ID,Trade,Date    DY37,2,19337,20120523

Need the excel file as below

 Name ID Trade Date DY37 2 19337 20120523

Can someone please help me.

---------- Post updated at 07:39 PM ---------- Previous update was at 05:14 PM ----------

xls foramt didnt work, used csv

2

You have 2 options.
Option 1: Open the file then go to menu DATA --> Text to Column. Follow simple instructions and will see the data in your format.

Option 2: Replace the comma's with Tab before you send an attachment in mail. Once you click the attachment, you will see the data in your format.

HOpe it will help you.

3

Looks to me like the file is in unix format and Excel probably wants a DOS formatted file.

Convert the file to DOS format before attaching to you email. To do this you can use unix2dos (if you OS supports it):

unix2dos yourfile.csv

Or use this command if you don't have unix2dos:

sed 's/$/'`printf "\015"`/ yourfile.csv > yourfile_fixed.csv
4

Hello,

I'm having a mail with a .csv attachment. I need to extract this attachment & store it in a text file.

Any ideas are really appreciated.

Thanks.