Đang Thực Hiện

Analyse data in excel and take out specific information

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

Kỹ năng: Xử lí dữ liệu, Excel

Xem thêm: test out, spreadsheet in html, html spreadsheet example, 192 168.1.1, specific data excel, take a test, test take, take some, OUT, macro excel, macro + excel, excel to html, excel html, data processing in excel, data log, data in, data analyse, analyse, analyse some data, macro script file, excel specific, excel macro txt, data collection excel spreadsheet, data collection spreadsheet, mac excel spreadsheet

Về Bên Thuê:
( 91 nhận xét ) moneyreagh, United Kingdom

Mã Dự Án: #1677433

Đã trao cho:

gangabass

I can do this for you. See PM for details.

£20 GBP trong 0 ngày
(65 Đánh Giá)
5.4

7 freelancer đang chào giá trung bình £29 cho công việc này

bouslimi1979

Please check PM. Thanks

£30 GBP trong 0 ngày
(59 Đánh Giá)
5.8
nagybatonyi

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 Thêm

£50 GBP trong 2 ngày
(53 Đánh Giá)
5.7
expertatwork

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.

£20 GBP trong 1 ngày
(61 Đánh Giá)
4.9
fkgeem10

sir, i can help you ,see my pm ,

£30 GBP trong 2 ngày
(0 Đánh Giá)
0.0
sshaider

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 Thêm

£20 GBP trong 1 ngày
(0 Đánh Giá)
0.0
halwaladdu

ready to start here.....

£35 GBP trong 2 ngày
(0 Đánh Giá)
0.0