[SOLVED] Displaying the cell in different color

nextStep · 10-20-2020, 11:51 AM

Hi Team,

My requirement is to display the value of html cell in red color based on the value in another cell .
Example:The value in the column "Actual count" should be displayed in red color as it is greater than value in "threshold" column.
The content of testresult.txt are as follows
Properties 20201020 281899 32000 Warning

Code:

fn_presentationLogic()
{

awk 'BEGIN{
FS=" "
print  "<HTML>""<TABLE border="1"><TH>Item</TH><TH>Date</TH><TH>Actual count</TH><TH>Threshold</TH><TH>Status</TH> "
}
 {
printf "<TR>"
for(i=1;i<=NF;i++)
printf "<TD>%s</TD>", $i
print "</TR>"
 }
END{
print "</TABLE></BODY></HTML>"
 }
'  testresult.txt > HotelDashboard.html

sed -i "s/Warning/<font color="red">$3<\/font>/g;s/Normal/<font color="green">$3<\/font>/g" HotelDashboard.html
}
fn_presentationLogic

I have used the above sed command to substitute the third cell if it finds "Warning" but in vain. Could you please advise.

berndbausch · 10-20-2020, 02:26 PM

Quote:

Originally Posted by nextStep

The content of testresult.txt are as follows
Properties 20201020 281899 32000 Warning

Code:

...
sed -i "s/Warning/<font color="red">$3<\/font>/g;s/Normal/<font color="green">$3<\/font>/g" HotelDashboard.html
}
fn_presentationLogic

I have used the above sed command to substitute the third cell if it finds "Warning" but in vain. Could you please advise.

There are several problems.
Problem 1: sed doesn't have the notion of columns. For sed, $3 is just the string "$3", not the third column.
Problem 2: You don't quote correctly. The first double quote is matched with the double quote before red. You then have an output redirection, $3, and input redirection plus more stuff. The result is probably an incorrect shell command, and definitely not a working sed command. You could fix that by replacing the very first and very last double quotes with single quotes, but unfortunately, problem 1 will subsist.

Since sed doesn't know anything about columns, it is not the right tool for the task. awk, on the other hand, is well-suited. I would add the logic of colouring column 3 to the awk command that you have written already. First though, make sure that the current awk command generates the expected output.

nextStep · 10-21-2020, 12:22 AM

Thanks Berndbausch.The current awk command is working fine , the html file is generating fine.Below is the output from awk command.
Item Date Actual count Threshold Status
Properties 20201020 281899 32000

Could you please shed some light on the awk logic for displaying the cell color as i was unable to find anything from my research on the various forums.
Thanks in advance.

berndbausch · 10-21-2020, 12:44 AM

Quote:

Originally Posted by nextStep

Thanks Berndbausch.The current awk command is working fine , the html file is generating fine.Below is the output from awk command.
Item Date Actual count Threshold Status
Properties 20201020 281899 32000

Could you please shed some light on the awk logic for displaying the cell color as i was unable to find anything from my research on the various forums.
Thanks in advance.

You say "The value in the column "Actual count" should be displayed in red color as it is greater than value in "threshold" column.".

This can be achieved by replacing the second action in your awk program with

Code:

{ 
    printf "<TR>"
    for(i=1;i<=NF;i++) { 
        if (i==2 && $2>$3)
           printf "<TD><font color=\"red\">%s</font></TD>", $i
        else
           printf "<TD>%s</TD>", $i
    }
    print "</TR>" 
}

I have not tested it. The idea is to check the condition actual count greater than threshold inside the for loop.

nextStep · 10-21-2020, 01:30 AM

Thanks a lot Berndbausch. This has resolved my issue. Much appreciated.