Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script
Top Forums UNIX for Beginners Questions & Answers Script Post 303015570 by bharti navlani on Friday 6th of April 2018 08:14:36 PM
Old 04-06-2018
Script
Hi,
I was trying to write a shell script which reads text file and sends mail in html format along with tables. Hope i have completed 1st part , but while sending mail i was trying to highlight some rows in the table based on the grep outcome. If the string contain **(194new.txt) , i am trying to highlight it(row) with a Red color. can you please help me where i have to write a code for putting the condition and what i need to mention. Thanks in advance

Code:
cat 194new.txt
NA
15223**
NA
5031
1628
NA
NA
NA
7637
4002
2240
4181
5395
5211
3718
5259
6477
1569
9047
7491
1282

Code:
HOME="/home/rbem/ovp/"
sed 's/^\s*$/NA/' 194.txt > 194new.txt
sed 's/^\s*$/NA/' new.txt > new1.txt
paste $HOME/a1.txt $HOME/194new.txt $HOME/new1.txt >$HOME/output
## send the mail ##
Date=`date "+%d-%m-%Y"`
MAIL_CMD_FILE='/home/rbem/ovp/MAIL'
SUB_LINE="BEM HCK $Date"
SupportId='bharti.nnn@ctctctct.com'
echo "/usr/sbin/sendmail -fsocket $SupportId << END" > ${MAIL_CMD_FILE}
echo "From:bharti.nnn@ctctctct.com" > ${MAIL_CMD_FILE}
echo "To: ${SupportId}" >> ${MAIL_CMD_FILE}
echo "Subject: ${SUB_LINE}" >> ${MAIL_CMD_FILE}
echo "Content-Type: text/html" >> ${MAIL_CMD_FILE}
echo "<p>" >> ${MAIL_CMD_FILE}
echo "<font size=\"2\">" >> ${MAIL_CMD_FILE}
echo "<font face=\"calibri\">" >> ${MAIL_CMD_FILE}
echo "<font size="3">Hi All</font><br>" >> ${MAIL_CMD_FILE}
echo "<br>" >> ${MAIL_CMD_FILE}
echo "<br>" >> ${MAIL_CMD_FILE}
echo "<font size="3">PFB details</font><br><br>" >> ${MAIL_CMD_FILE}
echo "<br>" >> ${MAIL_CMD_FILE}
echo "<table border=\"1\">" >>  ${MAIL_CMD_FILE}
echo "<tr><th style=background-color:#DCDCDC><font size="2"><font face=\"calibri\">EG</th><th style=background-color:#DCDCDC><font size="2"><font face=\"calibri\">194</th><th style=background-color:#DCDCDC><font size="2"><font face=\"calibri\">196</th></tr>" >> ${MAIL_CMD_FILE}
cat  $HOME/output| awk -F" " '{print "<tr><td><font face=\"calibri\">"$1"</td><td><align=\"center\"><font face=\"calibri\">"$2"</td><td><align=\"center\"><font face=\"calibri\">"$3"</td></tr>"}' >> ${MAIL_CMD_FILE}
echo "</table>" >> ${MAIL_CMD_FILE}
echo "<br>" >> ${MAIL_CMD_FILE}
echo "<br>" >> ${MAIL_CMD_FILE}
echo  "<font size="2"><b><u>Swap Memory usage for 194:</u></b></font><br>"
##echo "Swap Memory usage for 194"<br><br> >> ${MAIL_CMD_FILE}

cat /home/rbem/ovp/swap_194.txt >> ${MAIL_CMD_FILE}

echo "Thanks,<br>" >> ${MAIL_CMD_FILE}

echo "BEM TEAM" >> ${MAIL_CMD_FILE}
echo "</p>" >> ${MAIL_CMD_FILE}
echo "</font>" >> ${MAIL_CMD_FILE}
echo "</font>" >> ${MAIL_CMD_FILE}
cat ${MAIL_CMD_FILE} | /usr/lib/sendmail -t
echo " Mail send to intended recipients :: $SupportId ">> ${MAIL_CMD_FILE}

Last edited by Scrutinizer; 04-08-2018 at 02:33 AM.. Reason: Changed Other personal address as well
 

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies

2. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

5. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My... (3 Replies)
Discussion started by: siegfried
3 Replies
All times are GMT -4. The time now is 09:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy