Hi,

Simple question, is there a way to get the system decimal separator?

Thanks

Left ( .5 ; 1 )

So if a user use "," it will take automatically the coma.

Brillant!

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 )

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.

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 )

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"?

Of course no: there is an uman who reads that answer !

But the question was how to get from a machine the used separator.

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.

My hat off to you and Comment for your consistently brilliant solutions.

Left( 1/2 ; 1 ) is poetry. :

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.