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 PHP

mysqli_get_proto_info

MYSQLI_GET_PROTO_INFO(3)						 1						  MYSQLI_GET_PROTO_INFO(3)

mysqli::$protocol_version - Returns the version of the MySQL protocol used

       Object oriented style

SYNOPSIS

       string$mysqli->protocol_version ()

DESCRIPTION

       Procedural style
       int mysqli_get_proto_info (mysqli  $link)

	Returns an integer representing the MySQL protocol version used by the connection represented by the $link parameter.

PARAMETERS

	      o $
		link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)

RETURN VALUES

	Returns an integer representing the protocol version.

EXAMPLES

       Example #1

	      $mysqli->protocol_version example

	      Object oriented style

	      <?php
	      $mysqli = new mysqli("localhost", "my_user", "my_password");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      /* print protocol version */
	      printf("Protocol version: %d
", $mysqli->protocol_version);

	      /* close connection */
	      $mysqli->close();
	      ?>

	      Procedural style

	      <?php
	      $link = mysqli_connect("localhost", "my_user", "my_password");

	      /* check connection */
	      if (mysqli_connect_errno()) {
		  printf("Connect failed: %s
", mysqli_connect_error());
		  exit();
	      }

	      /* print protocol version */
	      printf("Protocol version: %d
", mysqli_get_proto_info($link));

	      /* close connection */
	      mysqli_close($link);
	      ?>

	      The above examples will output:

	      Protocol version: 10

SEE ALSO

       mysqli_get_host_info(3).

PHP Documentation Group 												  MYSQLI_GET_PROTO_INFO(3)