 Background Color change, Changing Background color based on column value of a HTML Report |
| D.Joe |
 Oct 4 2018, 01:37 PM
Post
#1
|
|
Group: Members Posts: 3 Joined: 4-October 18 Member No.: 26,722  |
Hi , i am using the below script to convert CSV File to HTML Table (Shell Script to be used) , and change the background color of the cell of 1st column, if the value is less than 100 to RED. If the value=100 then as is else RED..Below is the script/code (suggested in one of the Forums) , however the background color remains the same (Lemon Chifon) even for the values less than 100. I am new to HTML..Any help on this will be much appreciated..
BEGIN { print "<html><head>" print "<title >Title </title>" print "<style type=\"text/css\">" print ".error { print " color: red," print " font-size: larger," print "}" print "</style></head>" print "<body>" print "<p>The report provides overall Percentage Secured in the given subjects.</p>" print "<table border=1 bgcolor=\"LemonChiffon\" cellspacing=1 cellpadding=1>" } NR == 1 # Header row print "<tr>" print "<th><Score %></th>" print "<th><Status></th>" print "<th><Exam Date></th>" print "<th><Term></th>" print "<th><Subject></th>" print "</tr>" } NR > 1 { # Data rows print "<tr>" for ( i = 1; i <= NF; i++ ) { class = $i < 100 ? "class=\"error\"" : "" printf "<td %s>%s</td>\n", class, $i } print "</tr>" } |
  |
 
|
  |
Replies
| D.Joe |
Oct 4 2018, 08:19 PM
Post
#2
|
|
Group: Members Posts: 3 Joined: 4-October 18 Member No.: 26,722 |
@Charles , No the text color remains the same. it doesn't change... Style attrributes are not getting called i guess . Font/Color/BG-Color everything remains the same..Nothing changes...  ..Banging my head.. |
|
|
|
| pandy |
Oct 4 2018, 10:28 PM
Post
#3
|
|
🌟Computer says no🌟  Group: WDG Moderators Posts: 20,730 Joined: 9-August 06 Member No.: 6 |
Christian told you. The delimiter between property-value pairs should be a semicolon. Not a comma as you have it. Lite this.
CODE print ".error { print " color: red;" print " font-size: larger;" print "}" It still won't change the background, because you haven't defined a background color. |
|
|
|
| D.Joe |
Oct 5 2018, 01:46 PM
Post
#4
|
|
Group: Members Posts: 3 Joined: 4-October 18 Member No.: 26,722 |
Thank you so much Christian & Charles.
Christian was right by inserting the correct Background property and <Value> and by replacing the comma with semi colon has done the trick. I am now able to generate the Background color. Thank you once again to both Lastly one small doubt, how to centre-allign the following Header. It should come on top of the Column headers and centre allign. print "</p>"report provides overall Percentage Secured in the given subjects"</p>" Thanks alot... |
|
|
|
| Christian J |
Oct 7 2018, 04:51 PM
Post
#5
|
|
. Group: WDG Moderators Posts: 9,653 Joined: 10-August 06 Member No.: 7 |
QUOTE(D.Joe @ Oct 5 2018, 08:46 PM)  Thank you once again to both You're welcome! QUOTE Lastly one small doubt, how to centre-allign the following Header. It should come on top of the Column headers and centre allign. You could use a CAPTION element inside the table, its default styling is to be centered over the table grid. See http://www.htmlhelp.com/reference/html40/tables/caption.html You might also use a heading element (H1, H2 etc) and make its text centered with CSS "text-align: center". QUOTE print "</p>"report provides overall Percentage Secured in the given subjects"</p>" The above example starts with a P end tag, not a start tag, and the quote characters seem wrong... |
|
|
|
Posts in this topic
D.Joe Background Color change Oct 4 2018, 01:37 PM
CharlesEF Your CSS for .error doesn't change the backgro... Oct 4 2018, 02:18 PM Christian J This is incorrect:
(each CSS property/value pair... Oct 4 2018, 04:05 PM
pandy That's right - just forget about me. http://ww... Oct 5 2018, 02:19 PM |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 19th April 2024 - 05:28 AM |
Invision Power Board
© 2024 IPS, Inc.
Licensed to: HTMLHelp.com, LLC