Convert scientific/exponential format to number value

[richard_chilvers]

My CSV file contains phone numbers in the scientific format, eg.

441642318911 appears as 4.42E+11

Within Excel I can see the correct phone number but everything I have tried in QV gives me a value of 441000000000.

I haven't been able to find a solution on this forum - any ideas?

Thanks

[arulsettu]

try this

Num(Replace('4.42E+11', ',', '.'), '(dec)')

check this doc also

Conversion of Exponential Notation to Decimal numbers

[richard_chilvers]

I still get the same result ie. 441000000000

[arulsettu]

can you upload sample excel and with expected output

[richard_chilvers]

Sample attached.

I would expect the first value of [Cust phone] to be 441642318911.

Thanks

[HirisH_V7]

Hi ,

Check this

data:
LOAD * ,
   Num(Data, '(dec)') AS Decimal
INLINE [
Data
 4.42E+11
];

Output:

HTH,

Hirish

[arulsettu]

no file attached

[richard_chilvers]

[arulsettu]

this one works for me try this in your load

LOAD [CDR Id],

     [Daily Call Id],

     Num(Replace([Cust phone], ',', '.'), '(dec)') AS phone

from.......

[matiasinfantes]

Thank you! It resolved my problem with this number 1120180701030000, it was loaded as 1,12018070103e+15.  I applied the num function with '(dec)' and it returned the correct number 1120180701030000