Parsing Negative Values

["... you mean these fans?"]

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

[comment]

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

["... you mean these fans?"]

Comment,

Ok.

Thank you.