Shell Programming and Scripting

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

Code:

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

am getting excel file as below

Code:

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

Need the excel file as below

Code:

 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

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.

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):

Code:

unix2dos yourfile.csv

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

Code:

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

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.

Moderator's Comments:

Please start your own thread and do not hijack other threads. This thread is over 3-months old and bears no relation to your post. Please remember to post what Operating System and version you are running and what Shell you use. In this context, please describe your mail client.