Jeff,
Do a Table > Update Column column.
I'll assume that your columns are called LatDMS and LongDMS.
The following syntax will replace your current values, with parsed comma
values:
LATDMS = left$(LATDMS,2) +","+mid$(LATDMS,3,2)+","+mid$(LATDMS,5,5)
LONGDMS = left$(LONGDMS,3)+","+mid$(LONGDMS,4,2)+","+mid$(LONGDMS,6,5)
resulting in 51,58,50.0N and 176,36,01.0W, respectively.
Cheers,
William Donaldson
Senior Computing Geologist (GIS)
Data Directions
240 Jersey Street,
Wembley, WA 6014
AUSTRALIA
ph/fax: (08) 9284 1889
mobile: 0401 67 1889
email: [EMAIL PROTECTED]
============================================================================
======================
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Jeff Logan
> Sent: Tuesday, July 25, 2000 10:58
> To: [EMAIL PROTECTED]
> Subject: MI string syntax
>
>
> dear mappers,
>
> i have columns of lat and long with no commas, spaces, or dashes between
> DMS. the strings are 515850.0N 1763601.0W.
>
> i would like the correct syntax to parse out the DMS values and insert
> commas between them prior to converting to decimal degress.
>
> what is the best use of left$ or instr$ to do this using the
> update column
> command?
>
> left$(long,5) <insert ,> left$(long,6-7) <insert ,>
>
> any suggestions?
>
> -jeff
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
