Here's a sample of one online Webalizer file (stripped of reams of frequency and byte data) which is trivial to separate. Now imagine about half a million lines of such data in random
order.

I can strip out the hostnames by putting two identical target lists side-by-side in OpenOffice calc, stripping the dots (.) out of one, then applying "text to columns" and deleting all but the left-most five columns of the spreadsheet. Some non-complying IPv4's are left behind with leading letters in (usually) the first octets' column which grep might find easily. There will also be short hostnames that didn't have three dots, but grep should get those, too. Once that's done, subtract the IPv4 list from the original list ...


Reply via email to