point comma

Hi Benoit,

Have you tried just using the @val() function, that should change it to a numeric field and then setting your regional settings to French should change the appearance to a comma for the decimal.  Can you try that out and let me know if it works?  Numbers are stored the same way, how they appear is based on your computer's regional settings.

Brian

Hi Benoit,

Thanks for getting back to me, sorry I had forgotten about the @curval function as I am always working in an English environment so I fortunately don't have to worry about that, glad it is working for you.

Hi Benoit, can you share some examples and your regional settings and I will try it out on my system and see if I can get it to work for you.  You can email it to brian.element@ideascripting.com.  Also if you could show for the examples what you want it to look like I will see what I can do.

I don't have much experience changing my regional settings to french but looking at your curval equation shouldn't it be @curval("124.05648";",";".") and you should set you virtural numeric field to 5 decimal places if you want to see them all. Remember you are going from english number formatting to french number formatting so your equation will be the opposite of the example in the function help pane in IDEA.

I didn't test it but if you are creating a virtual numeric field with 5 decimal places on a computer with french regional windows settings the virtual numeric field should show up as 124,05648 on your machine.

Remember to use curval the original field with the number should have been imported as a character field and display something like 100,500.05648 in the character field that represents the english number formatting.