Results 1 to 8 of 8

data processing using excel

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2014
    Location
    Jerusalem, Israel
    MS-Off Ver
    2010
    Posts
    6

    data processing using excel

    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
    Last edited by amitai; 08-20-2014 at 08:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sheet-related processing causes Excel VBA Userform to stop processing Tab/Enter
    By Joaquin M Lopez Muno in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-22-2014, 03:02 PM
  2. Need help with Excel macro for some data processing
    By AirBeast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2014, 01:03 AM
  3. Reduce processing time for processing multiple excel sheets
    By rexer231 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2014, 09:25 AM
  4. Excel - bulk processing disparate spread sheets with common data into 1 table or SS
    By rblackcat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2013, 08:41 PM
  5. [SOLVED] Need advice on data processing formulas in Excel 2010
    By robinc1969 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-15-2013, 05:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1