Find Jobs
Hire Freelancers

Import Text File into Excel - repost

$2-8 USD / hour

Cancelled
Posted over 10 years ago

$2-8 USD / hour

I want to import a log text file into an Excel spreadsheet. I have attached the files for reference. The relevant data is contained in pairs of blocks of texts like this: [36] : <Rx> - 11:55:15.703 -Type : 0x04 (Event) -EventCode : 0xFF (HCI_LE_ExtEvent) -Data Length : 0x1C (28) bytes(s) Event : 0x051B (ATT_HandleValueNotification) Status : 0x00 (Success) ConnHandle : 0x0000 (0) PduLen : 0x16 (22) Handle : 0x002F (47) Value : 00:D3:01:46:01:95:03:5F:03:5B:03:62:37:33:12:B2: 1D:2D:80:7F Dump(Rx): 04 FF 1C 1B 05 00 00 00 16 2F 00 00 D3 01 46 01 95 03 5F 03 5B 03 62 37 33 12 B2 1D 2D 80 7F ------------------------------------------------------------------------------------------------------------------------ [37] : <Rx> - 11:55:15.718 -Type : 0x04 (Event) -EventCode : 0xFF (HCI_LE_ExtEvent) -Data Length : 0x14 (20) bytes(s) Event : 0x051B (ATT_HandleValueNotification) Status : 0x00 (Success) ConnHandle : 0x0000 (0) PduLen : 0x0E (14) Handle : 0x002F (47) Value : 7F:24:00:01:00:00:01:01:F2:FC:12:F2 Dump(Rx): 04 FF 14 1B 05 00 00 00 0E 2F 00 7F 24 00 01 00 00 01 01 F2 FC 12 F2 ------------------------------------------------------------------------------------------------------------------------ The log is organized in blocks and I want to extract pairs of blocks that contain ‘Value’ data. Like in the example above a pair of block numbers 36 and 37 with the “Value” containing the data in hexadecimal format. A complete row of excel data is generated when a pair of 20 byte and 12 byte Values are combined to form a hex string that is then converted to decimal . In this example: 00:D3:01:46:01:95:03:5F:03:5B:03:62:37:33:12:B2:1D:2D:80:7F + 7F:24:00:01:00:00:01:01:F2:FC:12:F2 = 00D301460195035F035B0362373312B21D2D807F7F24000100000101F2FC12F2 Convert to Decimal ([login to view URL]) Column 1: 00 -> 0 Column 2: D3 -> 211 Column 3: 01 -> 1 Column 4: 46-> 70 Column 5: 01 -> 1 Column 6: 95 -> 149 Column 7: 03 -> 3 Column 8: 5F -> 95 Column 9: 03 -> 3 Column 10: 5B -> 91 Column 11: 03 - > 3 Column 12: 62 - > 98 Column 13: 37 -> 55 Column 14: 33 -> 51 Column 15: 12 -> 18 Column 16: B2 -> 178 Column 17: 1D -> 29 Column 18: 2D -> 45 Column 19: 80 -> 128 Column 20: 7F -> 127 Column 21: 7F -> 127 Column 22: 24 -> 36 Column 23: 00-> 0 Column 24: 01-> 1 Column 25: 00-> 0 Column 26: 00-> 0 Column 27: 01-> 1 Column 28: 01-> 1 Column 29: F2-> 242 Column 30: FC-> 252 Column 31: 12-> 18 Column 32: F2-> 242 Iterate through each block pair until the end of the log.
Project ID: 5212855

About the project

Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of EGYPT
Cairo, Egypt
0.0
0
Payment method verified
Member since Sep 6, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.