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, 20169 yr by Mr. Ignoramus

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, 20169 yr by comment

Comment,

Ok.

Thank you.