Need to convert output.txt into html file Post: 302841945

Sponsored Content

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

08-08-2013

Moderator

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

Yoda

View Public Profile for Yoda

Visit Yoda's homepage!

Find all posts by Yoda

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. 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...

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 ...

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 ...

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...

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...

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 ...

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

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>

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...

LEARN ABOUT CENTOS

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

Free Software Foundation					    Nov 3 1999								  IGAWK(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to convert PS files to txt file?

Discussion started by: redlotus72

2. Shell Programming and Scripting

Format txt file as html table

Discussion started by: tetreb

3. Shell Programming and Scripting

Convert shell script output txt file to html table

Discussion started by: a12ka4

4. Shell Programming and Scripting

SQL query output convert to HTML & send as email body

Discussion started by: jagadeeshn04

5. Shell Programming and Scripting

Desired output.txt for reading txt file using awk?

Discussion started by: emily

6. Shell Programming and Scripting

Loop to convert text output in the HTML format

Discussion started by: rahul2662

7. UNIX for Dummies Questions & Answers

Convert Txt file to HTML table and email

Discussion started by: hitmanjd

8. Solaris

How to convert pdf file to txt?

Discussion started by: raopatwari

9. Shell Programming and Scripting

Convert shell script output txt file to html table

Discussion started by: sarajobmai

10. UNIX for Beginners Questions & Answers

Copy the content from txt file and create a html file

Discussion started by: DevAakash

LEARN ABOUT CENTOS

igawk