Hi everybody,

I have a logfile.txt which looks like this:
62.68.174.12 - - [01/Jan/2005:00:07:58 +0100] "GET /pubid-848078832/index/index_pdf.html HTTP/1.0" 200 2862 "-" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)" 0
62.68.174.12 - - [01/Jan/2005:00:08:01 +0100] "GET /pubid-848078832/show_pdf.html?/pdf/pubid-848078832_1043.pdf?page=9 HTTP/1.0" 200 130220 "-" "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)" 2
...

Now I want to insert Customer-IDs to each IP-Address in that logfile. The CustomerID could be seperated from the IP-Address by a ";" or as you like.

I have an Excel-table which provides the CustomerIDs for the IP-Addresses, BUT those IP-Addresses are ranges...

That table looks like this (I have it as an external TXT also):
IP-Address(Range) -- CustomerID
203.75.24.6 -- 290
203.75.24.5 -- 290
203.75.24.250 -- 295
203.75.23.20 -- 295
199.212.31.* -- 293
198.96.61.* -- 293
192.82.131.* -- 293
192.82.130.* -- 296
192.82.129.* -- 296
192.82.128.* -- 296
192.75.254.* -- 296
192.75.177.* -- 296
192.139.207.* -- 296
192.139.206.* -- 298
192.12.183.* -- 298
142.151.*.* -- 298


I found this so far, but I couldn't apply it:
http://forums.microsoft.com/MSDN/Sho...22180&SiteID=1

The logfile has about 100,000 lines, so I cannot import it into Excel anymore which I was able to do until recently. Now I heard it was possible to alter an external file - but I don't know how...

Is there a way, that a MAKRO will check into which range of IP-addresses the IP-address of each entry of the logfile falls, and which will then produce the according CustomerID and put it into the logfile???

Thanks so MUCH!!!