Re: [xsl] Working with Scientific Notation

Subject: Re: [xsl] Working with Scientific Notation
From: Jeff Kenton <jkenton@xxxxxxxxxxxxx>
Date: Fri, 04 Oct 2002 12:38:36 -0400
Michael H. Semcheski wrote:

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:

Current Thread