Ok... This has got to be an easy one...
When I do a location function (Location (accuracy {; timeout})) and set it to a text field in the database, the "negative" operator is omitted from the latitude or longitude numbers my google map ends up on the wrong part of Earth. This must be an easy fix...
Techtronix, checkout/study how it is done in the enclosed file. It works correctly.
Here is my script... I think its the "middlewords" hyphen in the negative GPS values that is throwing it off. Is that the problem? Workaround?
Absolutely the minus and plus are both ignored in middlewords.
Play with this Change the calculation to either v1 or v2 or v3 or v4 or v5 you will see what it produces
Let( [
V1 = "+37.400000, -121.980000";
v2= Left ( v1 ; Position ( v1 ; "," ; 1 ; 1 ) -1);
V3= Right ( v1 ; Length ( v1-v2 ) );
v4= MiddleWords ( v1 ; 1 ; 1 );
v5=MiddleWords ( v1 ; 2 ; 1 )
];
v3
)
In this case it is producing -121.980000 whereas with v5 it produces 121.980000
Nice, rouelf, thank you!
This produces numbers into a number field and holds the negative. This is how I do it.
gps_field = Substitute ( gps_field; ", "; "¶")
Lat = GetValue ( gps_field; 1)
Long = GetValue ( gps_field; 2)
Accuracy = GetValue ( gps_field; 3)
LocationValues ( )is a much better function to use in my opinion.
Agreed bigtom LocationValues is a better way of doing it and would be my choice. My Let statement was to illustrate the MiddleWords function and set parsing.
however LocationValues is a Text field so I am unsure what you mean by "This produces numbers into a number field and holds the negative"
Making a return delimited list and using GetValue does not lose the negative number In the list. FM handles it.
Got it working. All the tips helped. Made into a list and used Getvalue() to into managed variables. Thanks
OK as Location is a text based function not a numeric one there is not an obvious reason.
Are you sure the field is text?
also why ( (Location (accuracy {; timeout})) and not just Location (accuracy {; timeout})
What else is happening here?