Analyse data in excel and take out specific information
£20-250 GBP
Paid on delivery
Hi, we have .txt files which include logs and some of the lines are like the below
192.168.45.4 192.168.45.3 d0:23:db:49:a8:36 - [03/Jun/2012:16:48:24 +0100] "GET /[url removed, login to view] HTTP/1.1" 200 2556 "http://192.168.45.3/[url removed, login to view]" "Mozilla/5.0 (iPhone; CPU iPhone OS 5_1_1 like Mac OS X) AppleWebKit/534.46 (KHTML, like Gecko) Version/5.1 Mobile/9B206 Safari/7534.48.3"
We would like to be able to run a macro program or similar in excel. Basically we paste the log file or reference the log file into excel or similar program, run a script and it finds all lines like the above and pulls out the data and details in an excel spreadsheet in the following columns
DATE: TIME: URL: NAME: EMAIL: TELEPHONE: COMMENTS
Attached is an example log file
Project ID: #1677433
About the project
Awarded to:
7 freelancers are bidding on average £29 for this job
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering the usual Open file More
We are a team of 2 having a vast experience on excel VBA scripting. Looking forward to work with you. thanks !!! Please have a look at our message in your PMB.