"... you mean these fans?" Posted September 18, 2016 Share Posted September 18, 2016 (edited) Hi, I have a customer who wants to enter their Latitude and Longitude into one fields to avoid the human error, so they copy these values when they right / left click on the google map. I've tried my global field in Number and Text but I always get the "positive" value regardless of the negative and the filter I am using ? Here is the value the customer would paste into my global field: 12.918267, -65.841355 Any suggestions would be grateful, see attache calc's. Thank you. Edited September 18, 2016 by Mr. Ignoramus Link to comment Share on other sites More sharing options...
comment Posted September 18, 2016 Share Posted September 18, 2016 (edited) The problem here is that the LeftWords() and Right Words() functions extract whole words only - and the minus sign is considered punctuation. Try instead: LeftValues ( Substitute ( YourGlobalField ; ", " , ¶ ) ; 1 ) 1 hour ago, Mr. Ignoramus said: I've tried my global field in Number and Text It should be Text if it is to contain a comma-separated list of numbers. Edited September 18, 2016 by comment Link to comment Share on other sites More sharing options...
"... you mean these fans?" Posted September 18, 2016 Author Share Posted September 18, 2016 Comment, Ok. Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2904 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now