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
7 freelance font une offre moyenne de £29 pour ce travail
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 Plus
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.
I possess a unique talent for delivering highly complex technical information into terms and concepts that the end users can readily grasp. Furthermore, I am multi-task oriented, enjoy a challenge and continually st Plus