Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Hi. I'm currently trying to "format" a float number in a grid column and use spanish decimal and thousands separators. Ex: 1.234.567,89 .
is there any way on TWX to add that format ? I created a service which format the number, but returns a string, so if I try to sort that column later it doesn't sort "correctly".
Thanks in advance.
Solved! Go to Solution.
You could try going the localization route. To learn more about using localization tables please refer to Article Viewer | PTC
Please note that numeric translation currently is not fully functional/still undergoing development.
For the procedure itself, however, please refer to the following article:
https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS241828&lang=en_US
Particularly to this section:
In other words, you would need to change decimal token to “,” then thousands token to “.” And then set number format token to 0,000.00 (because the other two tokens will take care of the symbols).
You could try going the localization route. To learn more about using localization tables please refer to Article Viewer | PTC
Please note that numeric translation currently is not fully functional/still undergoing development.
For the procedure itself, however, please refer to the following article:
https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS241828&lang=en_US
Particularly to this section:
In other words, you would need to change decimal token to “,” then thousands token to “.” And then set number format token to 0,000.00 (because the other two tokens will take care of the symbols).
Hi, Polina. Really thanks for your comment, it was really helpful i could achieve what i was looking for
Absolutely! Glad you were able to achieve the result.