El_Pablo Posted March 12, 2010 Share Posted March 12, 2010 Hi, Simple question, is there a way to get the system decimal separator? Thanks Link to comment Share on other sites More sharing options...
comment Posted March 12, 2010 Share Posted March 12, 2010 Left ( .5 ; 1 ) Link to comment Share on other sites More sharing options...
El_Pablo Posted March 12, 2010 Author Share Posted March 12, 2010 So if a user use "," it will take automatically the coma. Brillant! Link to comment Share on other sites More sharing options...
Raybaudi Posted March 12, 2010 Share Posted March 12, 2010 Left ( .5 ; 1 ) Sure ? A system that has the comma as decimal separator will not accept that calculation. So I think that it is better the known: Left ( 1/2 ; 1 ) Link to comment Share on other sites More sharing options...
comment Posted March 12, 2010 Share Posted March 12, 2010 Sure ? Yes. True, the formula needs to be entered according to the setting being used at that time (this is true for ANY calculation posted here) - but once it's entered correctly, it will continue to work even if the settings are changed. Link to comment Share on other sites More sharing options...
Raybaudi Posted March 12, 2010 Share Posted March 12, 2010 Comment I do not want to criticize but, if we know that the system use the comma at the time we enter the formula, why do we need to ask to FileMaker ? IOW: why not use a more general formula ? ( that will continue to work even on a clone made by another system ) Link to comment Share on other sites More sharing options...
comment Posted March 12, 2010 Share Posted March 12, 2010 I think you are mixing two separate issues; suppose someone asks a question here, and the answer is 2^.5 - should I add a warning "if you are using comma as your decimal separator, then the formula must be changed"? Link to comment Share on other sites More sharing options...
Raybaudi Posted March 12, 2010 Share Posted March 12, 2010 Of course no: there is an uman who reads that answer ! But the question was how to get from a machine the used separator. Link to comment Share on other sites More sharing options...
comment Posted March 12, 2010 Share Posted March 12, 2010 I am afraid I still don't see your point. If 2^.5 is a legitimate answer, what's wrong with Left ( .5 ; 1 )? There is no difference between it and Left ( 1/2 ; 1 ), except it's a little faster. Link to comment Share on other sites More sharing options...
Vaughan Posted March 12, 2010 Share Posted March 12, 2010 My hat off to you and Comment for your consistently brilliant solutions. Left( 1/2 ; 1 ) is poetry. : Link to comment Share on other sites More sharing options...
El_Pablo Posted March 15, 2010 Author Share Posted March 15, 2010 Thanks to all! Both are good solution. ".5" will be converted in the right regional settings automatically. If I code with a "." in a "," system it will give me a syntax error, I just have to change it. And if I reopen this calculation in a "." system, it will be automatically modified. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5148 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