Shell Programming and Scripting

Hi Experts,
i need your help here


Need to send a report thru mail using unix shell script(AIX). can you help me to do this? . i tried "uuencode" with CSV format, but while reading report all values are in single column. i need each column values in separate cell.

Thanks in advance...

Welcome newbieabc,

Are you saying that the file was attached to the email okay? If so, then we need to check the format of your file.

Excel can read most things quite well, but I think your file is space separated. If you use a comma to separate the columns and then see what Excel makes of it, that might help. The CSV does stand for Comma Separated Values after all.

If this still doesn't help, change it to be a .txt file and then Excel will launch the import wizard and guide you through opening it where you can tell it the column separators/delimiters or fixed column widths or whatever.



I hope that this helps. Let us know how you get on.


Robin

It's also possible that you forgot to add carriage returns to your file before you sent it. Windows/Excel expects these, it will not see \n by itself as an indicator of a new line. To add them to a file:

Code:

sed 's/$/\r/' < input.csv > output.csv

Hi Robin,
Thank you very much for replying,
yes, i am able to send the file via mail (attachment). While opening the file in excel (whatever the format .CSV or .xls) the outputs are in single column.

eg:

Code:

A1 B1 C1 D1 E1...
hello welcome to unix forum

But i want like this.

Code:

A1... B1....... C1 D1.. E1....
hello welcome to unix forum

this should me done in shell script. i dont want to do anything in excel.

Please help me.

thanks,

---------- Post updated at 03:12 AM ---------- Previous update was at 03:07 AM ----------

Hi Corona688,

Thanks for your suggestion. I tried it, it didn't work. Can you please help?

Thanks,

Moderator's Comments:

Spaces are not trimmed by this site when you use CODE tags. If you don't use CODE tags, normal HTML processing will coalesce adjacent whitespace. However, there are single spaces in your sample input (even after CODE tags have been added).

Post a sample of your csv file.

Also, "it didn't work" is not a useful description to anyone trying to help. Did it generate an error, produce the wrong (or no) output? What?

Hi CarloM,
Sorry for the inconvenience,
It doesn't produce any error. but outputs are in single column, doesn't intended in Excel.

Here is my sample code:

Code:

ls -ltr /home/$USER >~/log.csv
sed 's/$/\r/' <~/log.csv >~/log1.csv
uuencode log1.csv log.csv >report
mail -s "Report" #email_id# <report

Thanks,

Code:

ls -ltr /home/$USER

That's not going to have any commas in it - hence, only 1 column.

Do you want all the data from ls, or just the filenames?