VBA: providing CustomerID for IP-Addresses in external logfile.txt
 

Hi everybody,

I am trying to add certain CustomerIDs to IP-Addresses in an externa
logfile.txt.

The logfile has about 100,000 lines, so I cannot import it into Exce
anymore which I was able to do until recently. Now I heard it wa
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] "GE
/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] "GE
/pubid-848078832/show_pdf.html?/pdf/pubid-848078832_1043.pdf?page=
HTTP/1.0" 200 130220 "-" "Mozilla/4.0 (compatible; MSIE 5.01; Window
NT 5.0)" 2
...

*Now I would like to add the Customer-IDs to each IP-Address in tha
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 o
IP-addresses the IP-address of each entry of the logfile falls, an
which will then produce the according CustomerID and put it into th
logfile???-

Thanks so MUCH!!

--
JVLenno
-----------------------------------------------------------------------
JVLennox's Profile: http://www.excelforum.com/member.php...fo&userid=3250
View this thread: http://www.excelforum.com/showthread.php?threadid=55961

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