Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

Convert scientific/exponential format to number value

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

9 Replies
arulsettu
Master III
Master III

try this

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

check this doc also

Conversion of Exponential Notation to Decimal numbers

richard_chilvers
Specialist
Specialist
Author

I still get the same result ie. 441000000000

arulsettu
Master III
Master III

can you upload sample excel and with expected output

richard_chilvers
Specialist
Specialist
Author

Sample attached.

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

Thanks

HirisH_V7
Master
Master

Hi ,

Check this

data:

LOAD * ,

   Num(Data, '(dec)') AS Decimal

INLINE [

Data

4.42E+11

];

Output:

exponential figg.PNG

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
arulsettu
Master III
Master III

no file attached

richard_chilvers
Specialist
Specialist
Author

arulsettu
Master III
Master III

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
Partner - Contributor
Partner - Contributor

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