HaiBai
Your thoughts, insights, and musings on this matter intrigue me
+304|5742|Bolingbrook, Illinois
Alright, I need to sort data from packets into a table.

https://i48.tinypic.com/9kyxed.png

Basically, each packet starts with

Code:

01 D9 D0 10
and ends with 28 00's, or like this:

Code:

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
Then the next packet starts.  Each packet has the same amount of characters, 138, and they all follow the exact same pattern.  I just need to extract the colored items into a table.  Is there some way I could tell excel that I want the 15th, 16th, 17th, 19th, 21st, 23rd, 30th, 34th, 36th, and then 89th and 90th character and put it into a table?  I don't need to extract the names in quotes or anything highlighted with red.  Thanks.
ghettoperson
Member
+1,943|6907

I wouldn't know how to get Excel to do it, but you could knock up some code in about 5 minutes that'd do it.
HaiBai
Your thoughts, insights, and musings on this matter intrigue me
+304|5742|Bolingbrook, Illinois

ghettoperson wrote:

I wouldn't know how to get Excel to do it, but you could knock up some code in about 5 minutes that'd do it.
Yeah I'm programming a little thing right now.

Board footer

Privacy Policy - © 2025 Jeff Minard