[libreoffice-users] Re: [Calc] Convert GPS coords from DMS to decimals?

Thanks everyone for the input.

Using regexes, I split the latitudes and longitudes so they're in their own
columns.


Brian Barker wrote
> I'm guessing that "O" means "east" (as in "ouest"?) and that the
> alternatives to "O" and 
> "N" are "E" and "S" respectively? 

Sorry, I didn't pay attention to that part.

O = ouest = West
E = est = East


Brian Barker wrote
> If 00°05'12"O 42°59'12"N is in A1, then
> =(MID(A1,12,2)+(MID(A1,15,2)+MID(A1,18,2)/60)/60)*((RIGHT(A1,1)="N")*2-1)
> will deliver 42.9866666667, and
> =(LEFT(A1,2)+(MID(A1,4,2)+MID(A1,7,2)/60)/60)*((MID(A1,10,1)="E")*2-1)
> will deliver -0.0866666667.

I tried this formula, but get error 509 ("operator expected"). Maybe it's
because the cell contains "Numbers"?

https://postimg.cc/w764P7Rm <https://postimg.cc/w764P7Rm>  



--
Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy