FireRandySanders Posted March 16, 2004 Posted March 16, 2004 OK, I finally figured out how to open my raw stats log in win xp............now for the $64 Million dollar question ~ is there any way possible to sort this file by the IP addresses? Quote
HCSuperStores Posted March 16, 2004 Posted March 16, 2004 If it were me, I would parse out the IP address in a spreadsheet program and then use the spreadsheet program to sort by the IP address. Quote
DarqFlare Posted March 16, 2004 Posted March 16, 2004 Yeah... That sounds like a good way to do it. You could also build a PHP script to do it, but that's just a bit more work, haha... Quote
FireRandySanders Posted March 19, 2004 Author Posted March 19, 2004 would it be possible to parse out the IP's along with the url that the person was at? What is the easiest way to parse them out into a spreadsheet (ie:excel) Thanks! Quote
HCSuperStores Posted March 19, 2004 Posted March 19, 2004 In Excel you can parse in a couple of different ways. If you are dealing with a "fixed width" line, where every line holds the same exact format in the same exact positions (i.e. IP address always starting at position X) then Excel will lead you through a Wizard of what columns to split the file up on. However, it may not be that the log file is set up this way (I haven't looked recently). In this case I use a couple of Excel formulas that figure out where to get the data from. It's easy to do if I have the data in front of me. If you want to send me a small subset of your file, like 5 records, I could do it up for you and you could use it for the rest of your entries. Let me know if I can help! Quote
schussat Posted March 19, 2004 Posted March 19, 2004 I'm pretty sure the log lines are delimited, not fixed length. Delimited by comma, maybe, with text fields quoted? Anyway, should be a piece of cake to parse. Quote
HCSuperStores Posted March 19, 2004 Posted March 19, 2004 Just to end any further confusion over formats, I brought up my raw access log. The positions (length) of the IP address does vary slightly which impacts the position of where the date lands. This means that the second option in Excel is what will work. Because the position changes, using the file parse technique will clip pieces of data. I didn't see anything that the fields were delimited by. Let me know if you need help with this. Quote
FireRandySanders Posted March 31, 2004 Author Posted March 31, 2004 worked like a charm Appreciate everyone's help!! Now I can review my stats and see where a couple of people have been 'traipsing' Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.