|
That's why we convert the thousands separator into blanks in ourYup - if you know the locale, you can convert the number. Another option is to compress out the thousands separator (either "." or "," depending on locale), then convert any commas to periods. At that point, you have a US-style number.
multilingual environment depending on the language in which the user works.
And convert the rest with the built-in-function into numeric values.
All numeric! Display file fields are defined as character and the
representation depends on the language used.
--> "1234567,89" --> 1234567,89
--> "1 234 567,89" --> 1234567,89 --> "1 234 567.89" --> 1234567,89 --> "123 456 789" --> 123456789
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
