point comma
Forums
Hi,
I'm looking for a formula what changes a character field (which includes digits with point "." for decimal number) to a numeric field with a comma "," (french presentation of numbers). I've tested @curval but I didn't suceed to have two digits after the comma. I don't understand why. Do you know a solution ?
Thanks in advance !
Hi Benoit, can you share some
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
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.
Hi Benoit,
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