Parse file and show in a particular format in excel sheet
HI All,
I am a beginner to VBA script . I need a urgent help you from you guys.
I need to parse two text files and to show the items in excel in a particular format.
Input
--------------
Time Input file1:
===========
|TIME|THREAD_ID:3086054296|dtcp_Init|ENTRY|13:16:825897777:635006|
|TIME|THREAD_ID:3086054296|dtcp_Init|EXIT|13:16:825897777:695502|
|TIME|THREAD_ID:3086063296|ake_socketSendBuffer|ENTRY|13:16:825897777:853741|
|TIME|THREAD_ID:3086063296|ake_socketSendBuffer|EXIT|13:16:825897777:855223|
.....
Heap Input File 2:
===========
|HEAP|THREAD_ID:3101717400|dtcp_Init|Total=16384|used=9744|free=6640|
|HEAP|THREAD_ID:3101717400|dtcp_Init|Total=16384|used=9936|free=6448|
|HEAP|THREAD_ID:3101717400|dtcp_ContextCreate|Total=16384|used=13272|free=3112|
|HEAP|THREAD_ID:3101725816|dtcp_AuthenticationSessionCreate|Total=20480|used=13320|free=7160|
|HEAP|THREAD_ID:3101725816|dtcp_DeviceAuthenticate|Total=20480|used=13344|free=7136|
....
Output in Excel:
------------------
As attached
Please help.
Thank you
PD
Attachment | Size |
---|---|
Profile.xlsx | 10.51 KB |
memoryprofile_log.txt | 982.85 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago