Analyse data in excel and take out specific information

£20-250 GBP

Abgeschlossen

Veröffentlicht

vor fast 12 Jahren

£20-250 GBP

Bezahlt bei Lieferung

Hi, we have .txt files which include logs and some of the lines are like the below [login to view URL] [login to view URL] d0:23:db:49:a8:36 - [03/Jun/2012:16:48:24 +0100] "GET /[login to view URL] HTTP/1.1" 200 2556 "[login to view URL]" "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

Data Processing

Excel

Projekt-ID: 1677433

Über das Projekt

7 Vorschläge

Remote Projekt

Aktiv vor 12 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@gangabass

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

£20 GBP in 0 Tag

4,9

(65 Bewertungen)

5,4

7 Freelancer bieten im Durchschnitt £29 GBP für diesen Auftrag

@bouslimi1979

Please check PM. Thanks

£30 GBP in 0 Tag

4,9

(59 Bewertungen)

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 dialog or a Control form containing information necessary to identify the current input and output files. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. However, your example in the project description and the attached sample file are different, could you clarify this issue? Regards!

£50 GBP in 2 Tagen

4,9

(53 Bewertungen)

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 in 1 Tag

4,8

(61 Bewertungen)

4,9

@fkgeem10

sir, i can help you ,see my pm ,

£30 GBP in 2 Tagen

0,0

(0 Bewertungen)

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 stay abreast of the latest advancements in the IT field.

£20 GBP in 1 Tag