Re: [xsl] Working with Scientific Notation

[Jeff Kenton <jkenton at datapower dot com>]

Michael H. Semcheski wrote:
> Hello,
>
> I was wondering if anyone knows of a good way to convert very small 
> numbers represented in scientific notation to a standard decimal.
>
> The situation is this:  
    ...
> Many of the values that are formatted as percents in 
> excel show up in scientifc notation (eg  -9.1053999999999996E-2) in the 
> xml output.  When I try to format them with format-number(), they show 
> up as NaN.
I assume from your comments that you  have already discovered that XSLT 1.0 
doesn't handle scientific notation (XSLT / XPath 2.0 will).

My recommendation is to do this as a string processing operation, with as 
little math as possible.  Just count the digits on both sides of the decimal 
point, find the value of the exponent, and move the decimal point to the right 
place, inserting extra zeros as necessary.  Use the programming language of 
your choice (not necessarily XSLT), depending on your intermediate file format.

Good luck.


--
--------------------------
Jeff Kenton
DataPower Technology, Inc.



XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list