Import Text File into Excel - repost
$2-8 USD / hour
$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
It's free to sign up and bid on jobs