I was given an excel
spreadsheet that contained around 300 co-ordinates that I need to plot in
MapInfo...Problem, the co-ordinates for both latitude and longitude are
all in the same cell, separated by a "-". eg. 40-30-41, and the cell
format is just general. If anyone has a quick solution to either separate
these numbers into three separate columns (then I can easily convert them into
degrees, minutes, seconds), or even better, if someone has devised a program
that will work in MapInfo to convert a column in this crummy format to decimal
degrees I would love to hear about it ASAP.
I have downloaded many
of the extra MapBasic utilities on this website and found many of them extremely
useful. If one of these will do that and I just haven't found it or
figured it out please let me know.
Thanks to anyone who can
solve this relatively simple, yet pain in the butt problem.
Ryan
-------------------------------------------------------------------
Ryan Richter
GIS Specialist
DC - Development Consultants
(215)
348-4239 ext. 110
Fax - (215) 348-4997
-------------------------------------------------------------------
Suite 312 Penn's Court
350 South Main St.
Doylestown, PA
18901
-------------------------------------------------------------------
