parsing scientific notation

kdm

Hello,
The data is stored as a varchar in ORACLE. and it is stored as 2.7E7
Is there some way to convert this into decimal (27000000) using BIRT template ie report designer ?
Help highly appreciated.

Cheers,
kdm

mwilliams

Hi kdm,<br />
<br />
This code should do it in a computed column:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
importPackage(Packages.java.text);
nf = new DecimalFormat("#.#E0"); //create a format to parse the string to a decimal
temp = nf.parse(row["ScientificFormatString"]);
</pre>