Mail csv as xls in shell

UNIX for Advanced & Expert Users
1

Hello,

I have one csv file(";" separated). I would like to mail it as an attachment in xls format.

I tried it using below command but its coming in one column. I wan to have different columns as per delimiter ";".

unix2dos FILENAME | uuencode FILENAME FILENAME.xls | mailx -s "Hi" mailid

Thanks

2

Try with this ..

$ sed 's,;,\,,g' file2 > csvfile
$ uuencode csvfile filename.csv | mailx -s "hi" abc@xyz.com

PS: Please dont double post ..

3

There is also a nice search function in this forum and if you enter "uuencode" or "mail" or both, you will get a lot of hits I bet.

5

thanks Jayan .... it worked :slight_smile: