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]+Fenton&txtEmail=darren%40blueapricot.ie&txtTelephone=013472365492&txtComments=+This+is+a+test+of+the+data+collection+system+ 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/[url removed, login to view] (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
Đã trao cho:
7 freelancer đang chào giá trung bình £29 cho công việc này
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.