I had data in the same format. I also used Excel, before importing the data. I used the RIGHT, MID AND LEFT functions to separate the data into three columns, then did my calculations to get decimal degrees.
-----Original Message----- From: Matthew Fossey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 7:15 PM To: '[EMAIL PROTECTED]' Cc: Mapinfo-L (E-mail) Subject: RE: MI-L converting degree decimal minutes to decimal degrees I usually do this in excel, by multiplying minutes by 60 and seconds by 3600. Maybe this could be done in Mapinfo itself, but I have found it easier and quicker to do it in a spreadsheet then import that data in. Interested in other's take on this. Regards, Matt Fossey GIS Officer Narrabri Shire Council 149o 47' 7"E -30 o 19' 55"S PH: (02) 6799 6826 FAX: (02) 6799 6888 EMAIL [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, 9 October 2001 2:05 PM To: [EMAIL PROTECTED] Subject: MI-L converting degree decimal minutes to decimal degrees I have a table with Lat/Long fields that are in degree decimal minutes (ddd� mm.mmm) , for example (09923081) which is 99� 23.081' And I need to convert those lat/long fields to decimal degrees in order to use the "create points" in MapInfo. But the only mbx programs I can find such as Dms_dec.mbx and Dmscnvrt.mbx will only convert decimal degrees to degrees minute seconds or vis-versa. Anyone know of an easy way of converting ddd�mm.mmm to ddd.ddddddd automatically? TIA Dan _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. ************************************************************************ ****************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Narrabri Shire Council, unless otherwise stated. For the purposes of the Copyright Act, the permission of the holder of copyright in this communication may be taken to have been granted, unless stated otherwise, for the copying or forwarding of this message, as long as both the content of this communication and the purposes for which it is copied or forwarded are work-related. ************************************************************************ ****************** _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
