X-Virus-Scanned: clean according to Sophos on Logan.com Return-Path: Received: from vms042pub.verizon.net ([206.46.252.42] verified) by logan.com (CommuniGate Pro SMTP 5.1c.2) with ESMTP id 1330271 for flyrotary@lancaironline.net; Mon, 31 Jul 2006 12:04:24 -0400 Received: from verizon.net ([71.99.169.156]) by vms042.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0J39001QCZAGUUED@vms042.mailsrvcs.net> for flyrotary@lancaironline.net; Mon, 31 Jul 2006 11:03:53 -0500 (CDT) Date: Mon, 31 Jul 2006 12:03:52 -0400 From: Finn Lassen Subject: Re: [FlyRotary] Any Excel wizards out there (datalogging) In-reply-to: To: Rotary motors in aircraft Message-id: <44CE29E8.7090900@verizon.net> MIME-version: 1.0 Content-type: multipart/alternative; boundary=------------020802040701090902070401 X-Accept-Language: en-us, en References: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax; PROMO) This is a multi-part message in MIME format. --------------020802040701090902070401 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Can't figure out your email address, so here goes. This is how I would do it. Import into Access: select file type "text" files. Pick option "fixed length". Then you can export it to an excel workbook from Access. There's actually a way to do it in Excel: Let us say all your data is in column A. Enter this in B1: =Mid(A1,1,4) (assuming the first data block is 4 characters, starting with the first character) C1: =Mid(A1,5,8) (assuming next column's data starts with the 5th character and is 8 characters long). And so on... You can click on B1 and grab the little black square in the lower right-hand corner of B1, drag it down to the bottom of the spreadsheet. This will dupilcate the formula correctly. Anyway, if you send me a speadsheet with column A populated, I can do it for you. Finn 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 --------------020802040701090902070401 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Can't figure out your email address, so here goes.

This is how I would do it.
Import into Access:
select file type "text" files.
Pick option "fixed length".

Then you can export it to an excel workbook from Access.

There's actually a way to do it in Excel:

Let us say all your data is in column A.
Enter this in B1:
=Mid(A1,1,4)
(assuming the first data block is 4 characters, starting with the first character)
C1:
=Mid(A1,5,8)
(assuming next column's data starts with the 5th character and is 8 characters long).
And so on...
You can click on B1 and grab the little black square in the lower right-hand corner of B1, drag it down to the bottom of the spreadsheet. This will dupilcate the formula correctly.

Anyway, if you send me a speadsheet with column A populated, I can do it for you.

Finn

Russell Duffy wrote:

Message
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

--------------020802040701090902070401--