Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

DMtoDD ( Latitude or Longitude )

Degrees Minutes to Decimal Degrees

  Average rating: 4.4 (18 votes) Log in to vote

Edward P. Asmus Asmus Consulting http://asmus.uga.edu

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/* ========================================================= Custom Function DMtoDD =========================================================== Purpose: Convert degrees minutes (DM) to decimal degrees (DD). Developer: Edward Asmus (edasmus@uga.edu) Calling: DMtoDD ( "38° 12.390'N" ) The result would be 38.2065. DM: Matches the form that is produced by Google Earth and can be used in Google Maps. Note that the degree symbol (°) is that used by Google Earth and Google Maps it is Unicode 176 (shift-option-8). The minutes are decimal minutes. There is no space between the minute sign (') and the hemisphere. Either latitude or longitude can be sent for conversion and it will be converted correctly. DD: The routine works for both latitude and longitude. If the latitude is in the southern hemisphere, it will be a negative value. If the longitude is in the western hemisphere, it will be a negative value. Reference: http://www.rapidtables.com/convert/number/degrees-to-degrees-minutes-seconds.htm ========================================================= */ Let ( [ ~locDegree = Position ( latORlon; "°"; 1; 1) ; ~theLength = Length ( latORlon ) ; ~result = If ( ( Position ( latORlon; "S"; 1; 1) > 0 ) or ( Position ( latORlon; "W"; 1; 1) > 0); "-"; "") ; ~result = ~result & Trim ( Left ( latORlon; ~locDegree - 1 ) ) ; ~result = ~result & Trim(Middle(latORlon; ~locDegree + 1; ~theLength -(~locDegree + 1)))/60 ] ; ~result ) Click to copy

Converts degrees minutes (DM) of a latitude or longitude to decimal degrees (DD). Latitude or longitude values in the southern or western hemispheres are returned as negative values. The DM values are of the form that can be obtained from Google Earth and used by Google Maps.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: