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]

Reply via email to