Received-SPF: pass
 receiver=logan.com; client-ip=209.225.28.161; envelope-from=dalemahan@charter.net
Message-ID: <42B07332.7050607@charter.net>
Date: Wed, 15 Jun 2005 13:28:02 -0500
From: Dale Mahan <dalemahan@charter.net>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
MIME-Version: 1.0
To: Rotary motors in aircraft <flyrotary@lancaironline.net>
Subject: Re: [FlyRotary] non-rotary question on spreadsheets
References: <list-1003091@logan.com>
In-Reply-To: <list-1003091@logan.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Kevin,

I don't have Quattro Pro, but I can import it into another file form. I 
would be happy to write a small script or program to parse the 
spreadsheet column containing the latitude and longitude into two 
columns of comma separated value text or into Excel so you could simply 
import the coordinates instead of manually parsing them and reentering.

If you can send me the figures, I can start  immediately.  You may want 
to send the material to me at dalemahan "at" charter "dot" net, or 
dmahan "at" lindenwood "dot" edu  rather than distributing it to the 
entire web group.

Thank you,

Dale Mahan
Associate Director of  I.S.
Assistant Professor of  I.T.
Lindenwood University


kevin lane wrote:

>  I am working with Quattro spreadsheets, which appear to be identical 
> to excel.  my work has me pasting the latitude, longitude into two 
> cells,  they originate, however, as one string, missing the decimal 
> points.  It seems stupid to be pasting and modifying the string, 
> hundreds of times in a row. I'd like to paste the pair into an empty 
> cell and then define the destination cells as the portion of the 
> lat/long string.  can you help me? I figure if I ask the right person 
> that this is a total no-brainer.
>
> example:    string that I copy from a map "-7719420, 3871104"
>
> I need to split it into two cells that would read "-77.19420"  and 
> "38.71104"
> they are always the same decimal precision, same length.  I don't see 
> a substr function when I look thru the help for Quattro.  I'm getting 
> tired of all the tabbing and deleting, not to mention it is very error 
> prone.
>    I will be correcting NAVTEQ maps for Jacksonville this week, the 
> US's largest city! (area-wise!)  Last time I spent any time there I 
> was bringing the brewery on-line! (1982?)  Reply off-list, of course.
>
> Kevin Lane  Portland, OR
> e-mail-> n3773@comcast.net
>
>
>
>>>  Homepage:  http://www.flyrotary.com/
>>>  Archive:   http://lancaironline.net/lists/flyrotary/List.html
>>
>