html formatting using awk


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting html formatting using awk
# 1  
Old 01-10-2011
html formatting using awk

Hi I have a file as given below:
HTML Code:
<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 Modified</CENTER></TD><TD><CENTER>/home/ustst/usstage/src/REPORTS/ADMIN</CENTER></TD></TR>
<TR><TD><CENTER>bid_extract.sh</CENTER></TD><TD><CENTER>Locally Modified</CENTER></TD><TD><CENTER>/home/ustst/usstage/src/REPORTS/BID</CENTER></TD></TR>
<TR><TD><CENTER>Work Area: /home/eatst/</CENTER></TD></TR>
<TR><TD><CENTER>all_validation_ea</CENTER></TD><TD><CENTER>Locally Modified</CENTER></TD><TD><CENTER>/home/eatst/estage/src/EA_FIW/DQ</CENTER></TD></TR>
<TR><TD><CENTER>dc_110b_post.sql</CENTER></TD><TD><CENTER>Needs Checkout</CENTER></TD><TD><CENTER>Not Found</CENTER></TD></TR>
I am using an awk script to get this output:
Code:
awk 'BEGIN{
        FS="|"
        print "<HTML><table border=1>"
        print "<TR><TH>Script Name</TH><TH>CVS Status</TH><TH>Script Location</TH></TR>"
     }
     {
        printf "<TR>"
        for(i=1;i<=NF;i++)
        printf "<TD><CENTER>%s</CENTER></TD>", $i
        print "</TR>"
     }
     END{
        print "</TABLE></HTML>"
     }' result_set > report_file.html

When the row has the following input,
HTML Code:
<TR><TD><CENTER>Work Area: /home/ustst/</CENTER></TD></TR>
the remaining columns appear black. I need to merge the row when the row starts with the pattern 'Work'. Please help
# 2  
Old 01-10-2011
Please provide an example of the expected output.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

HTML formatting in shellscript

I have written one script which connects to MYSQL database, fires one select query and send the results over an email, if there is any Output. But the Output which I am receiving over email is in text format. I need to get it dispalyed in tabular format to ensure better readability. Below is... (3 Replies)
Discussion started by: Sambit Sahu
3 Replies

2. Shell Programming and Scripting

Suffix formatting with awk

i would like to format the 9 character with suffix as "0". i tried below it doesn't work. >a=12345 > echo $a | awk '{printf "%-09s\n",$1}' >12345 required output is 123450000 can you guys help me out ? (7 Replies)
Discussion started by: expert
7 Replies

3. Shell Programming and Scripting

[Solved] Sending a HTML email from cli loses formatting.

Hi, I have a .sh file, to email a report of our backups from a linux machine. It looks like this (minus a few bits): echo "HELO $host.$domain" sleep 1 echo "mail from: vdrreport@$domain" sleep 1 echo "rcpt to:$mailto" sleep 1 echo "data" sleep 1 echo "subject: $host VDR-Report... (2 Replies)
Discussion started by: cognito
2 Replies

4. UNIX for Dummies Questions & Answers

awk formatting

Hi all, I'm writing a simple awk code: awk 'BEGIN {FS="|"};{print "Type\tNumber\ttypes\tTotal";};{print $1, "\t", $2, "\t", $3, "\t", $4, "\t";}' db_query.txt it gives me the result: Type Number types Total XXX 498.0 5100.0 5274.661 Type Number types Total... (7 Replies)
Discussion started by: messi777
7 Replies

5. Shell Programming and Scripting

formatting awk

when i try this awk its giving out put as below. awk '!(/^$/||/--/||/selected/||/^ *$/){print $1}' tmp.txt output ===== 1 2010-08-03-12.31.26.126000 how excluede the 1st line ? i mean i want output only 2nd line i.e 2010-08-03-12.31.26.126000; (5 Replies)
Discussion started by: rocking77
5 Replies

6. Shell Programming and Scripting

AWK formatting help.

Dear all I require help with AWK regarding this situation Input is : fn1 12345 fn1 23456 fn3 231513 fn1 22325 fn3 123125 Desired output is fn1 12345 23456 22325 fn3 231513 123125 (5 Replies)
Discussion started by: Peasant
5 Replies

7. UNIX for Dummies Questions & Answers

How would i mail in html format?(Formatting Help)

I have written a scripts that checks the load average of server and if it is more than 5 it send a mail describing Current Load Average and High CPU/RAM processes . The problem is I want to send these information in html form .I have done necessary coding to do the same but whenever i try to... (7 Replies)
Discussion started by: pinga123
7 Replies

8. UNIX for Dummies Questions & Answers

How would i mail in html format?(Formatting Help)

I have written a scripts that checks the load average of server and if it is more than 5 it send a mail describing Current Load Average and High CPU/RAM processes . The problem is I want to send these information in html form .I have done necessary coding to do the same but whenever i try to... (0 Replies)
Discussion started by: pinga123
0 Replies

9. Shell Programming and Scripting

formatting output in html

hello all. I was hoping someone may have an idea or two. I'm throwing together a shell script that does a lot of application and system level data collection. The idea is is you run it before/after restarting an application for later analysis. A lot of stuff is collected... resource stats,... (4 Replies)
Discussion started by: ebbtide
4 Replies

10. Shell Programming and Scripting

Formatting using awk

Let's say I write a simple script that contains the following: date | awk '{print $1}' date | awk '{print $2}' Of course, when I run the script the output will look similar to: Tue Mar What if I want my ouput to be on one line as follows: Tue Mar What changes would I need to... (2 Replies)
Discussion started by: cdunavent
2 Replies
Login or Register to Ask a Question

Featured Tech Videos