I have a web log file in .csv form where the first or second column is the IP Address of the person requesting the web site resource. One line per page request.
I desire a stand alone program running under Windows 7 32-bit that will look-up the IP Address and insert a column of the 'Organization' that address resolves to.
In addition, I would like a second column added for 'Country' for the IP Address.
In addition, there is a column with referrer data which includes (sometimes) the search phrase. This is generally preceded with 'q=". I would like this search phrase brought out to a new column.
As an example, [url removed, login to view] resolves to Chassis Plans in the United States.
The log files can have up to 100,000 lines and are generally under 10MB.
An example data file will be found at [url removed, login to view] by the end of the day in California, USA.