Re: Working with Scientific Notation

Play the video

Subject: Re: Working with Scientific Notation
From: Jeff Kenton <jkenton@xxxxxxxxxxxxx>
Date: Fri, 04 Oct 2002 12:38:36 -0400

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

Current Thread
Working with Scientific Notation Michael H. Semcheski - Fri, 4 Oct 2002 12:10:07 -0400 (EDT) David Carlisle - Fri, 4 Oct 2002 12:35:37 -0400 (EDT) Michael H. Semcheski - Fri, 4 Oct 2002 14:31:24 -0400 (EDT) Jeff Kenton - Fri, 4 Oct 2002 12:36:06 -0400 (EDT) <= Jeni Tennison - Fri, 4 Oct 2002 13:04:43 -0400 (EDT)

<- Previous	Index	Next ->
Re: Working with Scientific N, Michael H. Semcheski	Thread	Re: Working with Scientific N, Jeni Tennison
Re: Working with Scientific N, David Carlisle	Date	Re: Working with Scientific N, Jeni Tennison
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >