Re: Nmap results in spreadsheet format

["Eric Paynter" <eric () arcticbears com>]

On Mon, June 14, 2004 11:22 am, Bill Z. said:
> This is a simple task - here's my quick and dirty way of converting the
> plain-text nmap output (e.g., nmap-out) into an Excel file with html tags:
>
> echo "<table>" ; grep "^[0-9*]" nmap-out | awk '{print "<tr><td>" $1 \
> "<td>" $2 "<td>" $3}'; echo "</table>" > nmap-out.xls

Although the </td> and </tr> tags are optional in the HTML spec, I've seen
some browsers do funny things without them. I prefer to include them just
to be safe. Also, with my shell, the redirect to nmap-out.xls only applied
to the last command. The following fixes both potential problems, making
the example more portable:

echo "<table>" > nmap-out.xls
grep "^[0-9*]" nmap-out | awk '{print "<tr><td>" $1 \
"</td><td>" $2 "</td><td>" $3 "</td></tr>"}' >> nmap-out.xls
echo "</table>" >> nmap-out.xls

-Eric

--
arctic bears - affordable email and name services @yourdomain.com
http://www.arcticbears.com