Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk help for HTML

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk help for HTML
# 1  
Old 03-07-2013
awk help for HTML
Hi all,

I have a file as below input.csv
Code:
NAME,EMPNO,PHNO
kkk,1234,0000
nnn,456,8765
hhh,888,555
hhy,222,567

i want to convert this into HTML table im using this
Code:
awk -F"," 'BEGIN{print "<table border=1>" { print "<tr>";for(i=1;i<=NF;i++)print "<td><b><font face=\"verdana\"><font size=\"2\"><font color=\"Black\">" $i"</font></b></td>";print "</tr>"} END{print "</table>"}'

but i want only the firstline of input.csv
inside of <th>tags or with different colour that rest with normal another colour

---------- Post updated at 02:28 AM ---------- Previous update was at 02:27 AM ----------

that is just to differentiate the heading of columns from the rest
# 2  
Old 03-07-2013
Please always intent your code for better readability.

Here is how you can distinguish header from other records:
Code:
awk -F, ' BEGIN {
                print "<html><body>"
                print "<table border=1>"
} NR == 1 {
                print "<tr>"
                print "<td><font face=verdana size=2 color=black>" $1 "</font></td>"
                print "<td><font face=verdana size=2 color=black>" $2 "</font></td>"
                print "<td><font face=verdana size=2 color=black>" $3 "</font></td>"
                print "</tr>"
} NR > 1 {
                print "<tr>"
                print "<td><font face=verdana size=1>" $1 "</font></td>"
                print "<td><font face=verdana size=1>" $2 "</font></td>"
                print "<td><font face=verdana size=1>" $3 "</font></td>"
                print "</tr>"
} END {
                print "</table>"
                print "</body></html>"
} ' input.csv

This User Gave Thanks to Yoda For This Post:
zozoo
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk to extract value after keyword in html

Using awk to extract value after a keyword in an html, and store in ts. The awk does execute but ts is empty. I use the tag as a delimiter and the keyword as a pattern, but there probably is a better way. Thank you :). file <html><head><title>xxxxxx xxxxx</title><style type="text/css"> ... (4 Replies)
Discussion started by: cmccabe
4 Replies

2. UNIX for Beginners Questions & Answers

Html output with awk/sendmail

Hello All, I inherited maintenance of a script that uses awk on an input file (space delimited) and formats it into an html table and send out using sendmail. I know how to manipulate the print statements to add columns and rows, however that is the extent of my html knowlege. I've searched... (5 Replies)
Discussion started by: Big-J
5 Replies

3. UNIX for Beginners Questions & Answers

awk HTML Conditional Formating

I am receiving the below output in text format. The output is converted to HTML table using the code mentioned below output in text LogDate DayOfWeek/Hours _0_ _1_ _2_ _3_ _4_ _5_ _6_ _7_ _8_ _9_ _10_ _11_ _12_ _13_ _14_ _15_ _16_ ... (3 Replies)
Discussion started by: Dumpi16
3 Replies

4. Shell Programming and Scripting

Help with awk and html

Hi i have a file say test with the following output server share-name path acl ---------- ----------------------------... (2 Replies)
Discussion started by: venkitesh
2 Replies

5. Shell Programming and Scripting

Extract text from html using perl or awk

I am trying to extract text after keywords fron an html file. The keywords are reportLink":, "barcodedSamples": {", "barcodedSamples": {". Both the perl and awk run but the output is just the entire index.html not the desired output. Also for the reportLink": only the text after the second / until... (5 Replies)
Discussion started by: cmccabe
5 Replies

6. Shell Programming and Scripting

Awk/sed HTML extract

I'm extracting text between table tags in HTML <th><a href="/wiki/Buick_LeSabre" title="Buick LeSabre">Buick LeSabre</a></th> using this: awk -F "</*th>" '/<\/*th>/ {print $2}' auto2 > auto3 then this (text between a href): sed -e 's/\(<*>\)//g' auto3 > auto4 How to shorten this into one... (8 Replies)
Discussion started by: p1ne
8 Replies

7. Shell Programming and Scripting

awk to parse html file

Is it possible in awk to parse a webpage (EDAR Gene Sequencing - Genetic Testing Company | The DNA Diagnostic Experts | GeneDx), the source code is attached. <title> EDAR Gene Sequencing <dt>Test Code:</dt> <dd>156 </dd> <dt>Turnaround Time:</dt> <dd>6-8 weeks </dd> ... (4 Replies)
Discussion started by: cmccabe
4 Replies

8. Shell Programming and Scripting

Need help shell+awk+html

Hi, Can someone help me how to add header cell in html table if i use the script posted below? I use shell script to search in files and format output into html table. /bin/zcat /CDR/cdr_TC/calllogs*_*_$FORM_data*.gz | sed 's//;/g' | awk -F";" '{if($1~/'$FORM_msgid'/ &&... (8 Replies)
Discussion started by: vasil
8 Replies

9. Shell Programming and Scripting

awk to create two HTML Tables

I am working on awk script to generate an HTML format output. With input file as below I am able to generate a HTML file however I want to saperate spare devices in a different table than rest of the devices and which has only Bunch ID, RAW Size and "Bunch Spare" status columns. INPUT File : ... (2 Replies)
Discussion started by: dynamax
2 Replies

10. Shell Programming and Scripting

html formatting using awk

Hi I have a file as given below: <table border=1> <TR><TH>Script Name</TH><TH>CVS Status</TH><TH>Script Location</TH></TR> <TR><TD><CENTER>Work Area: /home/ustst/</CENTER></TD></TR> <TR><TD><CENTER>admin_export.sh</CENTER></TD><TD><CENTER>Locally... (1 Reply)
Discussion started by: sudvishw
1 Replies
Login or Register to Ask a Question