|
|
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
|
|