Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Add Color To html Doc

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Add Color To html Doc
# 8  
Old 06-17-2014
Sure you can do it like this, here NR is for rownumber; i is the column number :

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>"
}
NR==3 {
  print "<tr>"
  for( i = 1; i <= NF; i++ ) {
    printf "%s", "<td"
    if      (i==4 && $i=="none")  printf " bgcolor=#99FF33"
    else if (i==4 &&  $i+0 > 80)  printf " bgcolor=#FFCC33"
    else if (i==4 &&  $i+0 > 60)  printf " bgcolor=#FF3333"
    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:
jimmyf
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. 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... (7 Replies)
Discussion started by: DallasT
7 Replies

2. 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" ... (1 Reply)
Discussion started by: maddelav
1 Replies

3. 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... (12 Replies)
Discussion started by: mirwasim
12 Replies

4. 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 (7 Replies)
Discussion started by: DallasT
7 Replies

5. 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 (5 Replies)
Discussion started by: rsivasan
5 Replies

6. 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 Replies)
Discussion started by: i007
2 Replies
Login or Register to Ask a Question