How to extract the latitude and longitude from GPS...

Erez_Michaeli · 01-20-2020 03:16 PM

In workflow, what would be the formula if I just need the use latitude part of the GPS or longitude?

Thank you,

Bahbus

INDEX(
    SPLIT([GPSCoords], ",")
,1)

SPLIT() takes a value and turns it into a list, delimited by the value provided, in this case, the comma in the coordinates.

INDEX() takes in a list and a number to return the specific item at that number, if anything exists. In your case value 1 will be the latitude, and value 2 will be the longitude. Values other than those two will return with nothing in this instance.

Erez_Michaeli

Thank you for your help, it worked

LeventK

@Erez_Michaeli
Below expression will give you the Latitude of your location coordinate

LAT([LocationColumn])

How to extract the latitude and longitude from GPS coordinates workflow