latORlonFromPoint ( Point ; Type )

Returns a latitude or longitude from a point on earth.

Average rating: 4.8 (19 votes) Log in to vote

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

Sample input:

latORlonFromPoint ( "38.2065,-112.1822"; "lat" )

Sample output:

38.2065

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

/* =========================================================
                       Custom Function latORlonFromPoint
===========================================================

Purpose:  Return either the latitude or longitude from a point.

Developer:  Edward Asmus (edasmus@uga.edu)

Calling:  latORlonFromPoint( Point, Type)

Point:  The latitude and longitude information for a location on earth in the form of "39.2065,-112.1822".

Type: Can be either "latitude" or "longitude".  "lat" or "lon" can also be used.  Type can be in any case:  lower, upper, or mixed.

Example:  latORlonFromPoint ( "38.2065,-112.1822"; "lat" ) would return "38.2065".

========================================================= */

Let ( 
[
Type = Lower( Left ( Type; 3 ) ) ;
~commaLoc = Position ( Point ; "," ; 1 ; 1 ) ;
~pointLength = Length ( Point ) ;
~result = Case (
     Type = "lat" ; Left ( Point; ~commaLoc - 1) ;
     Type = "lon" ; Right ( Point; ~pointLength - ~commaLoc ) ;
     )
] ; 
~result
 )

Returns either the latitude or the longitude of a point. A point is of the form "latitude,longitude" that is useable in Google Earth or Google Maps if they are in decimal degrees (DD). The function is called with the point and a type. The type can be either "latitude" or "longitude" and may be shortened to "lat" or "lon". The type can also be in any case: upper, lower, or mixed.

Comments

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

latORlonFromPoint ( Point ; Type )

Comments

Support this website.

Support this website.