0

Hi,
I have a ksh script that will actually read a config file, run a SQL statement against database,store the output in temp, convert them to HTML format and that sends a user an html-formatted email. Usually once per email, there is an exclamation point popping up in the middle of the email. I've read somewhere about this happening because of some limit at 1000 character limit.

Can someone help me on this? Its really frustating to have this marks in the middle :(

1
Contributor
1
Reply
8
Views
2 Years
Discussion Span
Last Post by tharun207134
0
print -u3 "Content-Type: text/html; charset=utf-8\r\n";
print -u3 "Content-Transfer-Encoding:base64 \r\n";
print -u3 "\n<html>"
print -u3 "<body>"
print -u3 "<h1>$(grep REPORTTITLE $CFGFILE|cut -d'=' -f2)</h1>"
print -u3 "<p>$(grep REPORTHEADER $CFGFILE|cut -d'=' -f2)</p>"
# create report table
print -u3 '<table border="1">'
print -u3 "<tr><th>"
print -u3 `grep TABLEHEADS $CFGFILE|cut -d'=' -f2|sed -e 's/,/\<\/th\>\<th\>/g'`
print -u3 "</th></tr>"
print -u3 `sed -e 's/^/\<tr\> \<td\>/' -e 's/$/\<\/td\>  <\/tr\>/' -e 's/;/\<\/td\> \<td\>/g' $FILE`
print -u3 "\n</table>"



FILE is the csv file which is stored in tmp. That csv file contents are written to HTML output.
eg: output of the file

53  2014-12-25-01.08.00.000000  A
50  2014-12-25-01.09.00.000000  A
43  2014-12-25-01.10.00.000000  A
55  2014-12-25-01.1! 1.00.000000    A
49  2014-12-25-01.12.00.000000  A
54  2014-12-25-01.13.00.000000  A
47  2014-12-25-01.14.00.000000  A
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.