|
|
Message
If the data is ALWAYS in the same columns –
you can use the DATA/IMPORT menu function.
It is under “Data” then “Import
External Data” then “Import Data”
Select your file, then when the “Wizard
Dialog box” appears check the “Fixed Width” box. Click “Next”
and set where your columns start/stop by clicking in the numbered bar at the
top.
If it’s not a fixed position file –
send it to me and I’ll parse it for you.
Joe Hull
Cozy Mk-IV N31CZ (65 hrs - Rotary 13B NA)
Redmond (Seattle),
Washington
From: Rotary motors in aircraft
[mailto:flyrotary@lancaironline.net] On
Behalf Of Russell Duffy
Sent: Friday, July 28, 2006 12:52
PM
To: Rotary
motors in aircraft
Subject: ***SPAM*** [FlyRotary]
Any Excel wizards out there (datalogging)
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.
russell dot duffy at gmail dot com
|
|