Jump to content

Parsing Negative Values


This topic is 2773 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

 

 

Screen Shot 2016-09-18 at 8.24.24 AM.png

Edited by Mr. Ignoramus
Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

This topic is 2773 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.