Sponsored Content
Top Forums Shell Programming and Scripting Convert content of file to HTML Post 303022842 by Scrutinizer on Saturday 8th of September 2018 10:09:13 AM
Old 09-08-2018
Hi variable i is not set anywere,

Try something like this to start with:
Code:
awk '
  BEGIN {
    print "<table border="10">"
  }
  NF==1{
    print "<tr ><td colspan=\"2\"> "$i" </td></tr>"
    next
  }
  NF==2 {
    $3=$2
    $2=""
  }
  {
    s="<tr><td>" NR "</td>"
    for(i=1; i<=NF; i++) 
      s=s "<td>" $i "</td>"
    s=s "</tr>"
    print s
  }
  END {
    print "</table>"
  }
' file

or perhaps simply:
Code:
awk '
  BEGIN {
    print "<table border="10">"
  } 
  NF==1 { 
    print "<tr ><td colspan=\"2\"> "$i" </td></tr>"
    next
  }
  NF==2{
    $3=$2
    $2=""
  }
  { 
    printf "<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", NR,$1,$2,$3
  } 
  END {
    print "</table>"
  }
' file

You can also do it in shell..

Last edited by Scrutinizer; 09-08-2018 at 11:37 AM..
This User Gave Thanks to Scrutinizer For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help to convert Flat file to HTML

Hello I need help to convert flat file data to HTML Table format. I am generating everyday Flat file and want to convert into HTML Table format. The format of my file is: version host Total YRS NO APPS PSD 10 Sun 30 2 4 6 7 and flat... (11 Replies)
Discussion started by: getdpg
11 Replies

2. Shell Programming and Scripting

how to convert a html file to an .xml one

Hii every one. I have lots of .html files like: <html> <title> </title> <head> </head> <body> <ul id="SummaryRatings">4 stars </ul> <ul id="summaryList"> <p><b> Aurhor</b> </p> <p>wsfwfrfrtgretryetyrtyty</p> </ul> ...... ....... </body> </html> (6 Replies)
Discussion started by: kheyali Mitra
6 Replies

3. UNIX for Dummies Questions & Answers

convert csv to html file

Hi All, I am new to this forum,not sure where to post this query...so posted here Kindly need any of your help on the below ------------ I am using shell scripting and trying to convert a csv file to html file... example.csv --------------- Name Country Age Sex Andy India 25 ... (4 Replies)
Discussion started by: sumithra
4 Replies

4. Shell Programming and Scripting

Is it possible to convert text file to html table using perl

Hi, I have a text file say file1 having data like ABC c:/hm/new1 Dir DEF d:/ner/d sd ...... So i want to make a table from this text file, is it possible to do it using perl. Thanks in advance Sarbjit (1 Reply)
Discussion started by: sarbjit
1 Replies

5. Shell Programming and Scripting

Script to convert CSV file to HTML

Hi, I have made a a script which creates a csv file as daily database report However i want to covert that csv file to html because csv file does not have a good visibilty. So it is possible to have such csv to html coversion script. Your prompt help much appreciated. Thanks in advance (4 Replies)
Discussion started by: sv0081493
4 Replies

6. Shell Programming and Scripting

Script to convert csv file to html with good visibility

Hi, I have Below script which converts csv file to html succesfully.but the visiblity is simple in black n white. I want to have better visibilty of each columns in different colours(like green).As it is a Database report suppose some tablespace available space is less than 20% then it should... (7 Replies)
Discussion started by: sv0081493
7 Replies

7. Shell Programming and Scripting

Need to convert output.txt into html file

I have output.txt file generated through shell scripts which need convert in tabular format using html can you please help me output.txt Token State Date1 Date2 Description Name 34567 open 27/06/13 28/06/13 ... (5 Replies)
Discussion started by: vijay_rajni
5 Replies

8. Shell Programming and Scripting

Convert text file to HTML tabular format.

Please provide script/commands to convert text file to HTML tabular format. No need of styles and colours, just output and a heading in table is required. Output file will be send via email and will be seen from outlook. (script required without using awk). output file content: (sar... (7 Replies)
Discussion started by: Veera_V
7 Replies

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

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
HTML::Entities::Numbered(3pm)				User Contributed Perl Documentation			     HTML::Entities::Numbered(3pm)

NAME
HTML::Entities::Numbered - Conversion of numbered HTML entities SYNOPSIS
use HTML::Entities::Numbered; $html = 'Hi Honey<b>&hearts;</b>'; # convert named HTML entities to numbered (decimal) $decimal = name2decimal($html); # Hi Honey<b>&#9829;</b> # to numbered (hexadecimal) $hex = name2hex($html); # Hi Honey<b>&#x2665;</b> $content = 'Copyright &#169; Larry Wall'; # convert numbered HTML entities (decimal) to named $name1 = decimal2name($content); # Copyright &copy; Larry Wall $content = 'Copyright &#xA9; Larry Wall'; # convert numbered HTML entitites (hexadecimal) to named $name2 = hex2name($content); # Copyright &copy; Larry Wall $xml = '&quot;Give me &yen;10,000&quot; &gt; cherie&spades;'; # convert named HTML entities to numbered # except valid XML entities (decimal) $decimal = name2decimal_xml($xml); # &quot;Give me &#165;10,000&quot; # &gt; cherie&#9824; # to numbered except valid XML entities (hexdecimal) $hex = name2hex_xml($xml); # &quot;Give me &#xA5;10,000&quot; # &gt; cherie&#x2660; DESCRIPTION
HTML::Entities::Numbered is a content conversion filter for named HTML entities (symbols, mathmetical symbols, Greek letters, Latin let- ters, etc.). When an argument of "name2decimal()" or "name2hex()" contains some nameable HTML entities, they will be replaced to numbered HTML entities. And when an argument of "name2decimal_xml()" or "name2hex_xml()" contains some nameable numbered HTML entities, they will be replaced to numbered HTML entities except valid XML entities (the excepted "valid XML entities" are the following five entities: "&lt;", "&gt;", "&amp;", "&quot;", "&apos;"). By the same token, when an argument of "decimal2name()" or "hex2name()" contains some nameable num- bered HTML entities, they will be replaced to named HTML entities. (the exception "valid XML entities" means the following five entities: "&lt;", "&gt;", "&amp;", "&quot;", "&apos;") On version 0.03, the entities hash table is imported from HTML::Entities (with obsolete class "HTML::Entities::Numbered::Extra" for older releases of Perl). At the moment, 0.04 (or later) is included HTML::Entities::Numbered::Table to import HTML entities table, and thereby we do not need to have HTML::Entities (included in HTML::Parser distribution). This may be also useful for making valid XML (corrects the undefined entity references, and enhanced by addition of functions conform to the XML). FUNCTIONS
Following all functions are exported by default. * name2decimal Some included named HTML entities in argument of "name2decimal()" will be replaced to decimal numbered HTML entities. * name2hex Some included named HTML entities in argument of "name2hex()" will be replaced to hexadecimal numbered HTML entities. * decimal2name Some include decimal numbered HTML entities in argument of "decimal2name()" will be replaced to named HTML entities (If they're name- able). * hex2name Some include hexadecimal numbered HTML entities in argument of "hex2name()" will be replaced to named HTML entities (If they're name- able). * name2decimal_xml Some included named HTML entities in argument of "name2decimal_xml()" will be replaced to decimal numbered HTML entities except valid XML entities. * name2hex_xml Some included named HTML entities in argument of "name2hex_xml()" will be replaced to hexadecimal numbered HTML entities except valid XML entities. If you'd prefer not to import them functions into the caller's namespace, you can call them as below: use HTML::Entities::Numbered (); $decimal = HTML::Entities::Numbered::name2decimal($str); $hex = HTML::Entities::Numbered::name2hex($str); $named1 = HTML::Entities::Numbered::decimal2name($str); $named2 = HTML::Entities::Numbered::hex2name($str); $decimal = HTML::Entities::Numbered::name2decimal_xml($str); $hex = HTML::Entities::Numbered::name2hex_xml($str); AUTHOR
Koichi Taniguchi <taniguchi@livedoor.jp> Develop triggered by IKEBE Tomohiro <ikebe@cpan.org> Many thanks to Tatsuhiko Miyagawa <miyagawa@cpan.org> COPYRIGHT
Copyright (c) 2004 Koichi Taniguchi. Japan. All rights reserved. This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
HTML::Entities, <http://www.w3.org/TR/REC-html40/sgml/entities.html> perl v5.8.8 2008-03-06 HTML::Entities::Numbered(3pm)
All times are GMT -4. The time now is 02:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy