While Loop with if else condition Post: 302808989

Sponsored Content

Top Forums Shell Programming and Scripting While Loop with if else condition Post 302808989 by Yoda on Friday 17th of May 2013 09:35:27 PM

05-17-2013

Moderator

No need to use an external utility grep for checking if the pattern exists in each record.

You can read each field in the CSV by setting the IFS and perform the check:

Code:

{
        echo "To: user@domain.com"
        echo "Subject: Test HTML"
        echo "Content-Type: text/html"
        echo "<html><body>"
        echo "<table border=1 width=100% bgcolor=#DDDDDD>"
        while IFS="," read stu sub res dt tm
        do
                if [ "$res" == "Absent" ] || [ "$res" == "Failed" ]
                then
                        echo "<tr>"
                        echo "<td bgcolor=red>$stu</td>"
                        echo "<td bgcolor=red>$sub</td>"
                        echo "<td bgcolor=red>$res</td>"
                        echo "<td bgcolor=red>$dt</td>"
                        echo "<td bgcolor=red>$tm</td>"
                        echo "</tr>"
                else
                        echo "<tr>"
                        echo "<td>$stu</td>"
                        echo "<td>$sub</td>"
                        echo "<td>$res</td>"
                        echo "<td>$dt</td>"
                        echo "<td>$tm</td>"
                        echo "</tr>"
                fi
        done < file.csv
        echo "</table>"
        echo "</body></html>"
}

This User Gave Thanks to Yoda For This Post:

Yoda

View Public Profile for Yoda

Visit Yoda's homepage!

Find all posts by Yoda

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

What condition to be put in the while loop?

i have got a file where the env command is appended 5 times. i have to now look for the username and display it in the form of 1) PWD=/home/lee.ballancore 2) USER=lee.ballancore 3) MAIL=/var/spool/mail/lee.ballancore 4) LOGNAME=lee.ballancore 5) HOME=/home/lee.ballancore 6)...

2. UNIX for Dummies Questions & Answers

Testing For Loop condition

How do I test the return condition in the script if no files are found: for file in `Find ${LANDING_FILE_DIR}${BTIME_FILENAME_PATTERN}` do ... .. done I want to capture the return code so I can echo the error or condition. Using if ] always returns zero no matter where it's placed. ...

3. Shell Programming and Scripting

how can i put the condition in for loop for the below.

i have the equation like below 07:35:07 ( AB : 2319f.ab * 22) + ( AB : 2320f.ab * 22.03 ) + ( AB :2321f.ab * 22.07 ) ...... N i want put ":" as a delimiter and break the equation like below 2319f.ab * 22 2320f.ab *22.03 2321f.ab * 22.07 . . N i know the number of...

4. Shell Programming and Scripting

issues with a condition in a while loop

Hi, I am facing issues with test condition. I had a compound condition to write for both if and while, In one of the texts i referred, with a korn shell we can write compound statements like: ], however this doesn't worked for me. For example: if ] doesn't works, but if || worked. ...

5. Shell Programming and Scripting

if condition in a while loop

Gurus, I need to read a line from a file and strip the characters from it and compare the stripped value with the value I pass to the script while executing it. Below is the code for the same. But when i execute the code, it is throwing an error. #!/bin/ksh . /home/.i_env ...

6. Shell Programming and Scripting

Use of -z in while loop condition

Hi, Could you please tell what is the meaning of -z in while loop condition. For example, while ; do echo "*** Enter the age " readage

7. Shell Programming and Scripting

Leaving for loop on condition

hi all, i have a problem...no dream :-) i want to scan a file i use the loop famous while read line do do < myfile but this scan must finish when find the another string . How can i do it? best regards for all. Francesco Please use descriptive subjects. "script." doesn't tell...

8. Shell Programming and Scripting

Case loop condition

hello, I would like to do exit at the end ie list all errors before exiting How to put the token exit in a variable with a loop ? Thanks function g1 () { case "$1" in (-0-0 | -0-1 | -0-2 | -0-3 | -1-0 | -1-1 | -1-2 | -1-3) # nothing, OK ! ;; (*) echo 'Fatal, $1 = '"'$1'"', Date...

9. Shell Programming and Scripting

Check two condition in while loop

Hi, I Have to check two condition in while loop every 2 minutes. while loop is accompanied with number of times it will check.Please help in putting the two condition in while loop as appropriate. z= input value, A=1 while do 1.check the file output,if the file output is N then keep on...

10. Shell Programming and Scripting

For loop/while condition - doubt

hi., As we know that using for-loop or while condition, we can only process one by one sequentially, but , lets say this example : 1. under the folder "logs" there are 1000 files 2. each file has one record or line 3. have to perform atleast 7 queries per 3 seconds ,for instance ...

LEARN ABOUT OSX

shar

SHAR(1) 						    BSD General Commands Manual 						   SHAR(1)

NAME

     shar -- create a shell archive of files

SYNOPSIS

     shar file ...

DESCRIPTION

     shar writes an sh(1) shell script to the standard output which will recreate the file hierarchy specified by the command line operands.
     Directories will be recreated and must be specified before the files they contain (the find(1) utility does this correctly).

     shar is normally used for distributing files by ftp(1) or mail(1).

SEE ALSO

     compress(1), mail(1), tar(1), uuencode(1)

BUGS

     shar makes no provisions for special types of files or files containing magic characters.

EXAMPLES

     To create a shell archive of the program ls(1) and mail it to Rick:

	   cd ls
	   shar `find . -print` |  mail -s "ls source" rick

     To recreate the program directory:

	   mkdir ls
	   cd ls
	   ...
	   <delete header lines and examine mailed archive>
	   ...
	   sh archive

HISTORY

     The shar command appears in 4.4BSD.

SECURITY CONSIDERATIONS

     It is easy to insert trojan horses into shar files.  It is strongly recommended that all shell archive files be examined before running them
     through sh(1).  Archives produced using this implementation of shar may be easily examined with the command:

	   egrep -v '^[X#]' shar.file

4.4BSD								   June 6, 1993 							    4.4BSD

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

What condition to be put in the while loop?

Discussion started by: nehaquick

2. UNIX for Dummies Questions & Answers

Testing For Loop condition

Discussion started by: mavsman

3. Shell Programming and Scripting

how can i put the condition in for loop for the below.

Discussion started by: mail2sant

4. Shell Programming and Scripting

issues with a condition in a while loop

Discussion started by: amritps