Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Providing status info during UDF calculations | Excel Programming | |||
Providing Toolbars to Workgroup | Excel Discussion (Misc queries) | |||
How do I create a logfile | Excel Programming | |||
Providing for Applicaiton Update | Excel Programming | |||
How to get Username written in logfile (.txt) through macro | Excel Programming |