Hi,

I would like to know how to convert a text file in UNIX to HTML using awk?

For example,
my file has the following contents :

Name Age
A 23
B 16
C 60
D 29

How to output as html as a table?

Thanks!
mm

Hi,
If I understand correctly, you want to convert a columnar textfile to an HTML table.
The code below will do that:

echo "Type name of file to be converted"
read infile
outfile=$infile.html
echo "<table border=1>" > $outfile
cat $infile|while read line
do
echo "<tr>" >> $infile.html
echo $line|awk -v newfile=$outfile '{
for(i=1;i<=NF;i++)
{
print("<td>" $i "</td>") >> newfile
}
}'
echo "</tr>" >> $outfile
done
echo "</table>" >> $outfile

I am not sure if this site will let me post the html tags literally....I am giving it a try...
Anukta

Line no 7 should have been

echo "<tr>" >> $outfile

This is very basic HTML table, u might want to modify this to suit your requirement.
-Anukta

Hi,
I am basically making use of Anukta's code only but with a few changes, in way that i am avoiding the read of the file using cat command, rather i am using awk directly to interpret lines.

Here it is:

#!/bin/ksh
read infile?'Type name of file to be converted: '
outfile=$infile.html
nawk -v newfile=$outfile 'BEGIN{\
print "" > newfile
}
{
print "" >> newfile
for(i=1;i" $i "") >> newfile
}
print "" >> newfile
}
END{print "" >> newfile }' $infile

The difference between the code will be noticeable if you input file is large, else remains the same.

One more thing i am using nawk instead of awk as some machines dont understand the -v option, due to the older version of awk.

~deeps

well, i should have known that .... :-)

Let's try again....

#!/bin/ksh
read infile?'Type name of file to be converted: '
outfile=$infile.html
nawk -v newfile=$outfile 'BEGIN{\
print "

" > newfile
}
{
print "" >> newfile
for(i=1;i<=NF;i++)
{
print("") >> newfile
}
print "" >> newfile
}
END{print "

" $i "

" >> newfile }' $infile

hope this works....

Someone should take Anukta's idea and change the code on this web page, as it gets too slow to give an answer with those signs :)

~deeps

well, i should have known that .... :-)

Let's try again....

#!/bin/ksh
read infile?'Type name of file to be converted: '
outfile=$infile.html
nawk -v newfile=$outfile 'BEGIN{\
print "<table border=1>" > newfile
}
{
print "<tr>" >> newfile
for(i=1;i<=NF;i++)
{
print("<td>" $i "</td>") >> newfile
}
print "</tr>" >> newfile
}
END{print "</table>" >> newfile }' $infile

hope this works....

Someone should take Anukta's idea and change the code on this web page, as it gets too slow to give an answer with those signs :)

~deeps

This was an ugly experience :-(

Thanks all for your solutions!:)