How to convert double values in scientific notation to decimal form
Article ID: KB0076148
Updated On:
| Products | Versions |
|---|---|
| TIBCO Streaming | - |
Description
If a large decimal value is passed as a double data type, it is automatically converted to scientific notation. For example, 12529527 is returned as 1.2529527E7. This can cause issues, for example, when you wish to use the returned double value in XML messages where scientific notation is invalid.
Resolution
To return the double value in decimal form, serialize the double to a string using the StreamBase format() function. For example..
..returns a string value 12529527.
For details on using the format() function, refer to:
StreamBase Documentation > StreamBase References > StreamBase Expression Language Functions
format("{0,number,###.##}",double(12529527))
..returns a string value 12529527.
For details on using the format() function, refer to:
StreamBase Documentation > StreamBase References > StreamBase Expression Language Functions
Issue/Introduction
How to convert double values in scientific notation to decimal form
Feedback
Yes
No
Powered by
