Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

html formatting using awk

Login to Discuss or Reply to this Discussion in Our Community

 
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