Shell Programming and Scripting

Hi Chubler_XL, i tried with printf also..its not working.
i tried the below:

Code:

printf "%s %s  \n  \n " "${File[i]}"  "${Member[i]}" >> temp.txt

By not working what do you mean is the data all still on one line?

Are you inserting the contents of temp.txt into the email body, or attaching it to the email, I'm assuming your inserting it into the email body.

Check the contents of temp.txt what you want is two spaces in the front of every line in this file that you want starting on a new line. Outlook thinks any line without spaces in the front is part of the previous paragraph and joins it up.

Without code tags around you posted code it's a little hard to tell what use used but it looks like you dont have the 2 spaces at the front on the printf string. You need the printf to be like this:

Code:

printf "  %s %s\n  \n" "${File[i]}" "${Member[i]}" >> temp.txt

Hi Chubler_XL, Yes the data still comes in one line. I am attaching the file in the mail, its not body.
below is the code.

Code:

printf "  %s %s\n  \n " "${File[i]}"  "${Member[i]}"  >> temp.txt
cat temp.txt |sort|uniq|sed "1i File Names  \t \t Rejected Member Names\n" > rejmbrs.txt

if i check in Unix, the values are appearing in separate lines as per requirement in rejmbrs.txt.
But when i am attaching the rejmbrs.txt in my email, values are coming in one line.

OK that explains things.

Files in Windows/DOS are different to unix, they need \r\n on the end. Change your printf commands to put \r infront of any \n eg:

Code:

printf "%s %s\r\n" "${File[i]}"  "${Member[i]}"  >> temp.txt

Another option is to use the unix2dos program on your file before attaching:

Code:

unix2dos rejmbrx.txt

Hi Chubler_XL, Thanks a ton. You are the Unix Master. I am able to get desired result with your suggestion. Thanks again.

In CSV:

Code:

a,a.txt\r
b,b.txt\r
c,c.txt\r

Tab separated text is also well supported, without worries about ',' and '"'. But CSV is more robust, allowing you to put multi-line chunks into cells inside ":

Code:

John,Smith,"123 Main ST
Anytown, NJ 08088-121",Democrat\r
Sam,Jones,"234 2nd AVE
Othertown, PA 18088-3456",Republican\r

Hi DGPickett, Thanks for your suggestion. I will plan to use csv in stead of txt as enhancement.
Thanks a lot for the help i received.