Converting Degree Minutes Seconds (DMS lat/lng) to Decimal

Need help
1

I have lat longs stored in DMS format:

N45-44.7
W107-39.6

How do I convert them to Decimal format within Bubble so I can call them properly via Google’s API?

@soeren did you ever work it this way? I know you’ve worked it the reverse.

2

I would try separating the DMS into three parts (degrees, minutes, seconds), likely using extract with regex. Then you can use the below formula to convert to decimal. The expressions element (toolbox plugin) will likely be a helpful for the math.

Decimal Degrees = degrees + (minutes/60) + (seconds/3600)**

3

This topic was automatically closed after 70 days. New replies are no longer allowed.