Add Color To html Doc Post: 302906180

Sponsored Content

Top Forums Shell Programming and Scripting Add Color To html Doc Post 302906180 by Chubler_XL on Tuesday 17th of June 2014 06:53:06 PM

06-17-2014

Moderator

How about this as an example. this changes all cells and values >80 are red; > 60 are yellow and >30 are green:

Code:

nawk 'BEGIN {
FS=","
printf "<HTML>\n<body>\n<table border=\"1\" cellpadding=\"4\" style=\"border-collapse: collapse\">\n"
print "<th>Col1</th><th>Col2</th><th>Col3</th><th>Col4</th><th>Col5</th><th>Col6</th>"
print "<th>Col7</th><th>Col8</th><th>Col9</th><th>Col10</th><th>Col11</th>"
}
{
  print "<tr>"
  for( i = 1; i <= NF; i++ ) {
    printf "%s", "<td"
    if ($i+0>80) printf " bgcolor=#FF3333"
    else if ($i+0>60) printf " bgcolor=#FFCC33"
    else if ($i+0>30) printf " bgcolor=#99FF33"
    print ">" $i "</td>"
  }
  print "</tr>"
}
END { printf "</table>\n</body>\n</html>\n" }' a.csv > 1.html

This User Gave Thanks to Chubler_XL For This Post:

Chubler_XL

View Public Profile for Chubler_XL

Find all posts by Chubler_XL

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem when extracting the title of HTML doc

Dear all. I need to extract the title (text between <title> and </title>) of a set of HTML documents. I've found a command that makes the work of extracting the text, but it does not always work. It works with the next example: cat a.txt htmltext<title>This is a HTML...

2. Shell Programming and Scripting

Add color in CSV cells

hi, i have text file that file contains below information. Name,Roll,Mark,Total Sivasankar,2120,89,410 Raja,2212,87,425 i need to convert text file to CSV file also the heading(Name,Roll,Mark,Total) font should be BOLD and color should be RED. how can i set fonts in csv

3. UNIX for Dummies Questions & Answers

How to add '--color' with pipes?

Hi guys - I was wondering if there is a way to add 'color' to a grep I do like this below: fgrep -i "XYZ-1124354-P" mylog.log | tr "\001" " " | sed G

4. UNIX for Beginners Questions & Answers

HTML color code and tabluar issue

input data in a file servic webservice.somthing 200 OK servic1 webservice.somthing 200 OK servic1 webservice.somthing 400 BAD REQEST Below script is making tabular form perfectly. but there are two thing i am not able to achive 1.how can i color the complete row as red when it see '400' in...

5. Shell Programming and Scripting

Cell color based on Status in HTML output

Hi, I need to get the Status Column in Green if it is approved and Red if it is declined in the HTML output attachment#!/bin/bash body_csv="/authlistener/ProdA/service/queryRS.csv" body_html="/authlistener/ProdA/service/queryRS.html" ...

6. UNIX for Beginners Questions & Answers

How to add 'color' in a grep?

Hello friends - I use various grep commands to search for data in a file. However, to add 'color' seems to not work. Is there a way to add color to two items that i search? so that i can easily identify in hundreds of lines of output what i am looking for? zegrep abcdefg...

LEARN ABOUT DEBIAN

convert::color::cmyk

Convert::Color::CMYK(3pm)				User Contributed Perl Documentation				 Convert::Color::CMYK(3pm)

NAME

       "Convert::Color::CMYK" - a color value represented as cyan/magenta/yellow/key

SYNOPSIS

       Directly:

	use Convert::Color::CMYK;

	my $red = Convert::Color::CMYK->new( 0, 1, 1, 0 );

	# Can also parse strings
	my $pink = Convert::Color::CMYK->new( '0,0.3,0.3,0' );

       Via Convert::Color:

	use Convert::Color;

	my $cyan = Convert::Color->new( 'cmyk:1,0,0,0' );

DESCRIPTION

       Objects in this class represent a color in CMYK space, as a set of four floating-point values in the range 0 to 1.

CONSTRUCTOR

   $color = Convert::Color::CMYK->new( $cyan, $magenta, $yellow, $key )
       Returns a new object to represent the set of values given. These values should be floating-point numbers between 0 and 1. Values outside of
       this range will be clamped.

   $color = Convert::Color::CMYK->new( $string )
       Parses $string for values, and construct a new object similar to the above three-argument form. The string should be in the form

	cyan,magenta,yellow,key

       containing the three floating-point values in decimal notation.

METHODS

   $c = $color->cyan
   $m = $color->magenta
   $y = $color->yellow
   $k = $color->key
       Accessors for the four components of the color.

   $k = $color->black
       An alias to "key"

   ( $cyan, $magenta, $yellow, $key ) = $color->cmyk
       Returns the individual cyan, magenta, yellow and key components of the color value.

SEE ALSO

       o   Convert::Color - color space conversions

       o   Convert::Color::CMY - a color value represented as cyan/magenta/yellow

AUTHOR

       Paul Evans <leonerd@leonerd.org.uk>

perl v5.12.3							    2011-06-15						 Convert::Color::CMYK(3pm)