IANA Port Numbering

[TheExcession]

Does anyone have a compltet list of the IANA Port Numbers that is in a format I can use to put into a DB.

Either csv or xml would be perfect, though clean fixed with fields would also work..

I'm looking at web pages and trying to get the data into Excel, but so much of the formating is inconsistent (loads of tabs and all sorts of nonesense)means I'm spending hours just tidying up the data before I can get it into my DB.

I can make SQL statements in Excel, or Generate XML that my PHP scripts will load and parse, but so far the data is such a mess.

Anyone got a clean version they wouldn't mind giving to me.

thanks
Ex

[tuffer]

Google TCP port numbers xls, comes up straight away.

[zumbruk]

30 seconds with awk & grep & I have a csv file. Have a look at this;

http:/www.axalotl.demon.co.uk/misc/iana.

[tuffer]

zumbruk said:

30 seconds with awk & grep & I have a csv file. Have a look at this;

http:/www.axalotl.demon.co.uk/misc/iana.

Nope, thats a 404

This wil work though www.axalotl.demon.co.uk/misc/iana.csv

[tuffer]

zumbruk said:

30 seconds with awk & grep & I have a csv file. Have a look at this;

http:/www.axalotl.demon.co.uk/misc/iana.

And where are the other 55519?

[zumbruk]

tuffer said:

zumbruk said:

30 seconds with awk & grep & I have a csv file. Have a look at this;

http:/www.axalotl.demon.co.uk/misc/iana.

And where are the other 55519?

Still on the IANA web site. I wasn't going to do them all until our Excessive friend said that was OK.

[stigmundfreud]

might have it on www.stigmundfreud.f2s.com

user: photos
pass: letmein

but I aint tocuched that thing in years so dont quote me

Edited by stigmundfreud on Thursday 22 March 17:54

[TheMarko]

I used to use this, but dunno how up to date it as any more:

www.good-stuff.co.uk/useful/portfull.php

[TheExcession]

tuffer said:

zumbruk said:

30 seconds with awk & grep & I have a csv file. Have a look at this;

http:/www.axalotl.demon.co.uk/misc/iana.

Nope, thats a 404

This wil work though www.axalotl.demon.co.uk/misc/iana.csv

Sorry to be so late back!

Brilliant, that's pretty much perfect.

Many many thanks.

[zumbruk]

TheExcession said:

tuffer said:

zumbruk said:

30 seconds with awk & grep & I have a csv file. Have a look at this;

http:/www.axalotl.demon.co.uk/misc/iana.

Nope, thats a 404

This wil work though www.axalotl.demon.co.uk/misc/iana.csv

Sorry to be so late back!

Brilliant, that's pretty much perfect.

Many many thanks.

El gusto is mio.

If you want any changes, let me know - it was literally a 2 line shell script to turn the web page into a CSV file.