X-Virus-Scanned: clean according to Sophos on Logan.com Return-Path: Received: from rtp-iport-2.cisco.com ([64.102.122.149] verified) by logan.com (CommuniGate Pro SMTP 5.1c.2) with ESMTP id 1320811 for flyrotary@lancaironline.net; Fri, 28 Jul 2006 16:22:53 -0400 Received-SPF: softfail receiver=logan.com; client-ip=64.102.122.149; envelope-from=echristley@nc.rr.com Received: from rtp-dkim-1.cisco.com ([64.102.121.158]) by rtp-iport-2.cisco.com with ESMTP; 28 Jul 2006 16:22:07 -0400 X-IronPort-AV: i="4.07,193,1151899200"; d="scan'208"; a="94301501:sNHT24207910" Received: from rtp-core-1.cisco.com (rtp-core-1.cisco.com [64.102.124.12]) by rtp-dkim-1.cisco.com (8.12.11.20060308/8.12.11) with ESMTP id k6SKM7OV009371 for ; Fri, 28 Jul 2006 16:22:07 -0400 Received: from xbh-rtp-201.amer.cisco.com (xbh-rtp-201.cisco.com [64.102.31.12]) by rtp-core-1.cisco.com (8.12.10/8.12.6) with ESMTP id k6SKM7Yh006988 for ; Fri, 28 Jul 2006 16:22:07 -0400 (EDT) Received: from xfe-rtp-202.amer.cisco.com ([64.102.31.21]) by xbh-rtp-201.amer.cisco.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 28 Jul 2006 16:22:07 -0400 Received: from [64.102.38.136] ([64.102.38.136]) by xfe-rtp-202.amer.cisco.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 28 Jul 2006 16:22:06 -0400 Message-ID: <44CA71EE.2020601@nc.rr.com> Date: Fri, 28 Jul 2006 16:22:06 -0400 From: Ernest Christley Reply-To: echristley@nc.rr.com User-Agent: Mozilla Thunderbird 1.0.7-1.4.1 (X11/20050929) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Rotary motors in aircraft Subject: Re: [FlyRotary] Any Excel wizards out there (datalogging) References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 28 Jul 2006 20:22:06.0966 (UTC) FILETIME=[7F1C5160:01C6B283] Authentication-Results: rtp-dkim-1.cisco.com; header.From=echristley@nc.rr.com; dkim=neutral 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 |