How to split Web log file from a server so that it can compare IP address and last box details?
I have a log file from a Web server with 120,000 lines. The data it contains are in the form:
18.104.22.168;14/Nov/201100:01:38;/media-f/irs?option=com_rsgallery2&page=inline&gid=2&limit= 1&Itemid=50;-;"Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)"
I need to somehow split it.
Then compare the IP address and the last box that contains the version of the web browser.
And so I identify the users.
Do you have any idea how to do this?
Which method to use?