Creating an HTML table with BASH & AWK

Question

I am having issues creating a html table to display stats from a text file. I am sure there are 100 ways to do this better but here it is:

(The comments in the following script show the outputs)

#!/bin/bash

function getapistats () {
    curl -s http://api.example.com/stats > api-stats.txt
    awk {'print $1'} api-stats.txt > api-stats-int.txt
    awk {'print $2'} api-stats.txt > api-stats-fqdm.txt
}

# api-stats.txt example
#    992 cdn.example.com
#    227 static.foo.com
#    225 imgcdn.bar.com
# end api-stats.txt example

function get_int () {

    for i in `cat api-stats-int.txt`;
        do echo -e "<tr><td>${i}</td>";
    done
}

function get_fqdn () {

    for f in `cat api-stats-fqdn.txt`;
        do echo -e "<td>${f}</td></tr>";
    done

}

function build_table () {

echo "<table>";
echo -e "`get_int`" "`get_fqdn`";
#echo -e "`get_fqdn`";
echo "</table>";
}

getapistats;

build_table > api-stats.html;

# Output fail :|
# <table>
# <tr><td>992</td>
# <tr><td>227</td>
# <tr><td>225</td><td>cdn.example.com</td></tr>
# <td>static.foo.com</td></tr>
# <td>imgcdn.bar.com</td></tr>

# Desired output:
# <tr><td>992</td><td>cdn.example.com</td></tr>
# ...

The single quotes go outside the curly braces. I know it works like that, but at the next simple increment in complexity it fails. Don't use for i in $(cat) - use while read -r; do ...; done < filename. Use $() instead of backticks. — Dennis Williamson
– Dennis Williamson, Commented Jul 14, 2012 at 20:27

score 11 · Accepted Answer · 2018-02-04 21:18:49Z

11

This is reasonably simple to do in pure awk:

curl -s http://api.example.com/stats > api-stats.txt
awk 'BEGIN { print "<table>" }
     { print "<tr><td>" $1 "</td><td>" $2 "</td></tr>" }
     END   { print "</table>" }' api-stats.txt > api-stats.html

Awk is really made for this type of use.

edited Feb 4, 2018 at 21:18

answered Jul 14, 2012 at 21:34

user1461760

Sign up to request clarification or add additional context in comments.

2 Comments

Heinrich Hartmann Over a year ago

You can pipe the output of this directly to a browser using bcat or this little script on OSX

lolololol ol Over a year ago

Shouldn't the last <tr> be `<\tr>' instead?

geirha · Accepted Answer · 2012-07-14 21:37:02Z

6

You can do it with one awk at least.

curl -s http://api.example.com/stats | awk '
    BEGIN{print "<table>"} 
    {printf("<tr><td>%d</td><td>%s</td></tr>\n",$1,$2)}
    END{print "</table>"}
'

answered Jul 14, 2012 at 21:37

geirha

6,4751 gold badge33 silver badges38 bronze badges

Comments

Zoltán Haindrich · Accepted Answer · 2012-07-14 19:43:45Z

0

this can be done w/ bash ;)

    while read -u 3 a && read -u 4 b;do
      echo $a$b;
    done 3</etc/passwd 4</etc/services

but my experience is that usually it's a bad thing to do things like this in bash/awk/etc

the feature i used in the code is deeply burried in the bash manual page...

i would recommend to use some real language for this kind of data processing for example: (ruby or python) because they are more flexible/readable/maintainable

answered Jul 14, 2012 at 19:43

Zoltán Haindrich

1,81713 silver badges21 bronze badges

1 Comment

jdorfman Over a year ago

yeah python might be the way to. Thanks bud ;)

Collectives™ on Stack Overflow

Creating an HTML table with BASH & AWK

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related