point comma

8 posts / 0 new
Last post
BENOIT
Offline
Joined: 11/29/2018 - 11:25
point comma

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 !

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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

BENOIT
Offline
Joined: 11/29/2018 - 11:25

Hi Brian,
The function @val() didn't worked.
Exemple of caracter field I would like to change : 124.054648 to numeric field : 124,05
The function @curval(124.05648;" ";",") like the function @val(124.05648) return 124,00.
Thanks for your help

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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.

BENOIT
Offline
Joined: 11/29/2018 - 11:25

I may have misspoke myself. The two functions don't work : I would like to get the decimals numbers.
Do you have an idea ?

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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.

Steven Luciani
Offline
Joined: 07/31/2012 - 13:20

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.

BENOIT
Offline
Joined: 11/29/2018 - 11:25

Yes, it works, thank you Steven !