|
Posted to microsoft.public.excel.programming
|
|
|
providing CustomerID for IP-Addresses in external logfile.txt
Google it
"JVLennox" wrote in
message ...
Hi everybody,
I am trying to add certain CustomerIDs to IP-Addresses in an external
logfile.txt.
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... :(
I have a *logfile.txt *which looks like this: (2 lines)
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 would like to add the Customer-IDs to each IP-Address in that
logfile.* The CustomerID could be seperated by a ";" or as you like.
I have an Excel-table which provides the CustomerID for the IP-Address,
BUT those IP-Addresses are ranges... :(
That table looks like this (I have it as an external TXT also):
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
-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!!!
--
JVLennox
------------------------------------------------------------------------
JVLennox's Profile:
http://www.excelforum.com/member.php...o&userid=32505
View this thread: http://www.excelforum.com/showthread...hreadid=559619
|