data processing using excel

[amitai]

Hi to all,
First of all I'm new here so forgive me if I'm not clear enough.

I want to receive and display data in a convenient and clear interface so that I can detect changes in a repeated sequence.
The data consists serial hexadecimal characters which are transmitted to a usb port constantly.
every string consists 4 Hexadecimal characters. ( 08c2 08f2 0911 0911 ...)
for displaying the data in the first place I'm using a terminal software "realterm" (there's no terminal software in windows 7).

realterm Capture.PNG

There's an option in the software to capture the incoming data and save it to a txt file. As you can see in the image the display
in the software can consist spaces which is good for my purposes, but when captured to the txt file the whole data is one big string with
no spaces, therefor trying to copy the txt file to excel also results in a one long string. I managed in other data types to use the text import wizard successfully. In order to be able in excel to arrange the data in columns I programmed the transmitted data so that every after 8 strings been transmitted there's an "FF" transmitted.

In the realterm software there's an explanation of how to control the software via excel but I didn't understand
how to do that:
http://realterm.sourceforge.net/real....html#contents

eventually what I'm seeking is to see (if possible) at real time in excel the data in a convenient display -
more or less that I can scroll the data and find easily changes in the sequence.

Thanks,
Amitai

[Bernie Deitrick]

Post an example of your text file. You can read the data line by line from the file and split it by character count very easily. For example:

Please Login or Register  to view this content.

[amitai]

Thanks for the quick answer,
Were do I insert the code? I haven't done programming in excel, is it through VB somehow?

here's an example of the received data:

Please Login or Register  to view this content.

[Bernie Deitrick]

Read characters.xlsm

Try this file - click the button, and choose the text file. You can repeat when you want to refresh the data.

[amitai]

Thanks!
I have two more questions:
What's the way for organizing the data in columns and not in a long row - say every 10 columns in a row?
can you explain generally in a few words or guide my by a link how to do this type of programming?
I'm here for learning...

[Bernie Deitrick]

You need to use a slightly more complicated parsing technique - also, E sometimes is interpreted as Exponential, so I changed all the cells to text to prevent Excel from auto-changing those values - just paste this over the existing macro...

Please Login or Register  to view this content.

[amitai]

I tried to replace the newer code instead of the existing vba and that resulted in an error.
Do I need to open a new sheet for the new code?
Amitai

[Bernie Deitrick]

Read characters 2.xlsm

Here's the file with the revised code.