Mailing List flyrotary@lancaironline.net Message #32916
From: Ernest Christley <echristley@nc.rr.com>
Subject: Re: [FlyRotary] Any Excel wizards out there (datalogging)
Date: Fri, 28 Jul 2006 16:22:06 -0400
To: Rotary motors in aircraft <flyrotary@lancaironline.net>
Russell Duffy wrote:

Greetings,
 
This is only distantly related, since it might be a way to collect data from the EM2, but for now it's for my Dynon.  I'm looking for someone who knows a lot more about excel than I do.  I have managed to collect raw serial data from the Dynon, which is a string of about 120 ASCII characters per line.  I need to be able to import this into Excel, but have it spread out across multiple columns.  For example, I might want the first two characters of each line in the first column, then the next four characters in the 2nd column, etc, defining how many characters go in each column.  If there were delimiters in the data, it would be easy, but there aren't any.   If anyone can help me figure out how to do this, please email me offlist.  I really don't want to clutter the list with this.   Thanks,
Rusty russell dot duffy at gmail dot com

If you've got a Linux box sitting around I could write you a script to parse it and write a comma delimited file.  Only take ten lines or so.  Something I'll be doing anyway.  Can you send me a representative sample?

--
        ,|"|"|,              Ernest Christley       |
----===<{{(oQo)}}>===----    Dyke Delta Builder      |
       o|  d  |o        http://ernest.isa-geek.org  |
Subscribe (FEED) Subscribe (DIGEST) Subscribe (INDEX) Unsubscribe Mail to Listmaster