Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need to convert output.txt into html file
Top Forums Shell Programming and Scripting Need to convert output.txt into html file Post 302841945 by Yoda on Thursday 8th of August 2013 09:18:29 AM
Old 08-08-2013
You mentioned earlier that space delimits description and name but that is not going to help because space in description itself will cause problems.

So in order to avoid complexities always create an output with fields clearly separated by any delimiter.

Anyway try this awk program and see if it helps:
Code:
awk '
        BEGIN {
                print "<html>"
                print "<body>"
                print "<table border=1>"
        }
        NR == 1 {
                print "<tr>"
                for ( i = 1; i <= NF; i++ )
                        print "<td>" $i "</td>"
                print "</tr>"
        }
        NR > 1 {
                print "<tr>"
                for ( i = 1; i <= 4; i++ )
                        print "<td>" $i "</td>"
                l = match ( $0, /[a-zA-Z0-9]*-/ )
                n = match ( $0, /[a-zA-Z]*,/ )
                print "<td>" substr ( $0, l, n - l ) "</td>"
                print "<td>" substr ( $0, n ) "</td>"
                print "</tr>"
        }
        END {
                print "</table>"
                print "</body>"
                print "</html>"
        }
' file

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to convert PS files to txt file?

Hi, I need to convert PS files to txt file. I thought of using ps2ascii, but its not installed in my AIX box, any other option? (2 Replies)
Discussion started by: redlotus72
2 Replies

2. Shell Programming and Scripting

Format txt file as html table

I have a short time to solve a problem, so I need some help. I've searched the forum, but I couldn't find a solution to my problem. I made a script to filter some text and now I have a new requirement to make it available as html table. Problem is that I more than one files with different set... (2 Replies)
Discussion started by: tetreb
2 Replies

3. Shell Programming and Scripting

Convert shell script output txt file to html table

Hi, I have script which generates the output as below: Jobname Date Time Status abc 12/9/11 17:00 Completed xyz 13/9/11 21:00 Running I have the output as a text file. I need to convert it into a HTML Table and sent it thru email ... (6 Replies)
Discussion started by: a12ka4
6 Replies

4. Shell Programming and Scripting

SQL query output convert to HTML & send as email body

Hi , I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body. p_id src_system amount 1 A 100 2 B 200 3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies

5. Shell Programming and Scripting

Desired output.txt for reading txt file using awk?

Dear all, I have a huge txt file (DATA.txt) with the following content . From this txt file, I want the following output using some shell script. Any help is greatly appreciated. Greetings, emily DATA.txt (snippet of the huge text file) 407202849... (2 Replies)
Discussion started by: emily
2 Replies

6. Shell Programming and Scripting

Loop to convert text output in the HTML format

Hello Everyone, I have a sample file raw.txt as shown below : Drive Bays Bay Name : SD-2C Number of Standby Power Supplies : 4 Number of Drive Enclosures : 12 Summary Status of Contained Modules All... (6 Replies)
Discussion started by: rahul2662
6 Replies

7. UNIX for Dummies Questions & Answers

Convert Txt file to HTML table and email

Hi all I need help converting a text file into a html table in bash and I need to email this table. The text file looks like the below. Two columns with multiple rows. Top row being header. Application Name Application Status Application 1 Open Application 2 ... (2 Replies)
Discussion started by: hitmanjd
2 Replies

8. Solaris

How to convert pdf file to txt?

Hello Unix gurus, I am learning unix. I have lots pdf data files. I need to convert them into txt files. Can you please guide me how to do that? Thanks in advance. Rao (1 Reply)
Discussion started by: raopatwari
1 Replies

9. Shell Programming and Scripting

Convert shell script output txt file to html table

My concnern related to the post -Convert shell script output txt file to html table, in this how to print the heading as color. awk 'BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' <filename> (8 Replies)
Discussion started by: sarajobmai
8 Replies

10. UNIX for Beginners Questions & Answers

Copy the content from txt file and create a html file

I have a txt file with a list of error messages in a xml tag format, and each error message is separated with a identifier(endresult).Need to split that and copy and create a new html file.Error message has some special character. how to escape the special character and insert my data into the... (7 Replies)
Discussion started by: DevAakash
7 Replies

LEARN ABOUT DEBIAN

flow-rptfmt

flow-rptfmt(1)						      General Commands Manual						    flow-rptfmt(1)

NAME

       flow-rptfmt -- Format the output of flow-report in ASCII or HTML

SYNOPSIS

       flow-rptfmt [-hHnp]  [-a alarm_time]  [-f format]  [-F fields]  [-m max_lines]  [-s sort_field]

DESCRIPTION

       The  flow-rptfmt  utility processes the CSV output of flow-report into formatted ASCII or HTML.	Sorting, maximum display lines, field fil-
       ter, header display, and name substitution are supported during post processing.  Additionally an alarm can be set for use in  CGI  scripts
       to limit the CPU time of formatting.

OPTIONS

       -a alarm_time
		 Exit after alarm_time seconds.

       -f ascii|html
		 Set output format.  Defaults to ASCII.

       -F display_fields
		 Limit columns to display_fields

       -h	 Help.

       -H	 Display header information.

       -m max_lines
		 Limit rows to max_lines.

       -n	 Enable symbol table lookups.

       -p	 Display in percent total form.

       -s sort_field
		 Sort on sort_field.  Prepend with + for ascending, - for descending sort.

EXAMPLES

       Format  the  output  of	daily-ip-protocol.txt  in  ASCII.  Display the ip-protocol and octets fields in percent total format with symbols.
       Limit output to top 5 sorted by octets.

	   cat daily-ip-protocol.txt | flow-rptfmt -fascii -Fip-protocol,octets -p -n -m5

BUGS

       Sorting could be faster.  Percent totals could be faster.  May not work with flow-report prior to 0.68.

AUTHOR

       Mark Fullmer maf@splintered.net

SEE ALSO

       flow-tools(1)

																    flow-rptfmt(1)
All times are GMT -4. The time now is 04:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy