There used to be some simple functions to strip the values on either side of the decimal point (integer and truncate?) but I can't find those anymore. There's an example from the help menu that comes close (below).
Alternatively, you might try this. I haven't tried it out, so there may be an error in the math, but you get the idea. If you've got -ve DD you'll have to convert to +ve first. @D = floor(DD); @M = floor((DD-@D)*60); @S = ((DD-@D)*60-@M)*60; DMS = @D*10000 + @M*100 +@S; Help file extract. Example: Geographic Conversion Using Temporary Variables (@) If your mathematical expressions consist of a number of steps, you can use temporary variables (identified by an ampersand and name, @A1for instance) to hold interim calculations. You can implement interim calculations either step-by-step (in the Formula= entry field or MATHEMATICAL GX) or as a series of statements in a file (MATHFILE GX). For more information about using complex expressions, refer to the Application Help for the MATH GX or the MATHFILE GX. The following example shows a sample conversion of a geographic coordinate defined in DEG SEC MIN or DEG.SECMIN format to a decimal equivalent. This calculation also shows the use of the FLOOR(x) statement. For more information about this statement, refer to the Special Tab topic. To convert latitude (LAT) of 12 degrees 34 minutes and 56 seconds to a decimal equivalent, calculate the following: Expression Result @A1 = FLOOR (LAT); 12 @A2 = LAT – FLOOR(LAT); 0.3456 @A3 = FLOOR (@A2 * 100); 34 @A4 = FLOOR (@A2 * 100) - @A3; 56 LAT = @A1 + @A3 / 60 + @A4 / 3600; 12.58221 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of mwape_somanje Sent: Tuesday, February 25, 2014 9:32 AM To: Geosoft Oasis montaj and Target Subject: [geonet] Converting Coordinates from DD to DMS Dear All Does anyone know the easiest way of converting the lot of coordinates from = decimal degrees to degrees minutes seconds. I have tried via ArcMap can't f= ind a way through, anyone know if it can be done in target? Regards Mwape --- Forum archives can be accessed here: http://lyris.geosoft.com/read/?fourm=geonet You are currently subscribed to geonet as: [email protected]. To subscribe or unsubscribe from any of our forums, select the User Forum selection on the Geosoft Community page: http://www.geosoft.com/support/community --- Forum archives can be accessed here: http://lyris.geosoft.com/read/?fourm=geonet You are currently subscribed to geonet as: [email protected]. To subscribe or unsubscribe from any of our forums, select the User Forum selection on the Geosoft Community page: http://www.geosoft.com/support/community
