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
# 1  
Old 06-17-2014
Add Color To html Doc
I have a script which converts a .csv file to html nicely. Trying to add 3 colors, green, yellow and red to the output depending upon the values in the cells. Tried some printf command but just can't seem to get any where. Any ideas would be appreciated.
Code:
nawk 'BEGIN{
FS=","

print  "<HTML>""<TABLE border="1"><TH>Col1</TH><TH>Col2</TH><TH>Col3</TH><TH>Col4</TH><TH>Col5</TH><TH>Col6</TH><TH>Col7</TH><TH>Col8</TH><TH>Col9</TH><TH>Col10</TH><TH>Col11</TH>"  
}
 {
printf "<TR>"
for(i=1;i<=NF;i++)
printf "<TD>%s</TD>", $i
print "</TR>"
 }
END{
print "</TABLE></BODY></HTML>"
 }
' a.csv > 1.html

# 2  
Old 06-17-2014
Please show the input you have and the output you want.
# 3  
Old 06-17-2014
For table cell color use HTML td tag and bgcolor attribute.

For table cell font color use HTML font tag and color attribute.
# 4  
Old 06-17-2014
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:
jimmyf
# 5  
Old 06-17-2014
Getting an error code Chub
Code:
nawk: syntax error at source line 1
 context is
 <<<    BEGIN >>>  {
nawk: illegal statement at source line 1
nawk: syntax error at source line 2

# 6  
Old 06-17-2014
Strange this is working OK for me with gnu awk - how did you get the script onto your Solaris box did you edit it in windows and transfer. If so your file may be in DOS format.

Try using dos2unix your_script_filename to convert the file into unix format
This User Gave Thanks to Chubler_XL For This Post:
jimmyf
# 7  
Old 06-17-2014
Code:
dos2unix

did it. Can this logic be applied to specific rows and columns ie
Code:
r=3, c=4

? Instead of numerical logic, can an instance of a cell that contains say the word "none" be targeted as green for example?
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