topic Re: convert exponential number to decimal in QlikView

convert exponential number to decimal

Anonymous — Wed, 15 Oct 2014 16:56:06 GMT

variation field exponential number to decimal converting: 2.5332 e-007

Re: convert exponential number to decimal

maxgro — Wed, 15 Oct 2014 17:29:27 GMT

num(

Left(replace('2.5332 e-007', ' ', ''), Index(replace('2.5332 e-007', ' ', ''), 'e') -1)

* Pow(10, TextBetween(replace('2.5332 e-007', ' ', ''), 'e', ''))

, '#,##0.0000000000')

replace '2.5332 e-007' with your field

also have a look at this

How to convert an exponential no to decimal

Re: convert exponential number to decimal

MarcoWedel — Wed, 15 Oct 2014 19:30:37 GMT

Hi,

you could also try like:

hope this helps

regards

Marco

Re: Re: convert exponential number to decimal

MarcoWedel — Wed, 15 Oct 2014 19:36:31 GMT

or in the script like:

LOAD *,
     Num(number, '(dec)') as numberDecimal
INLINE [
    number
    1.5639e-003
    2.5332e-007
    9.6548e-005
    4.7657e-009
    1.5639e003
    2.5332e007
    9.6548e005
    4.7657e009
];

hope this helps also

regards

Marco

Re: convert exponential number to decimal

maxgro — Wed, 15 Oct 2014 19:49:34 GMT

where do you find (dec)?

EDIT: found, in online help