csv load: Can't read numbers in exponential form

[#1]

Hi

I am trying to load datasets from CSV file as follows:

TAB1:

    LOAD Name,

               Score,

               Address

    FROM (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Now lets say for following sample structure of Dataset.csv, TAB1.Scores field in Qlikview is not being resolved into 68587640. It is because CSV has this field stored as 6.86E+07.

Name	Score	Address
John	1109342	NewYork
James	6.86E+07	Ohio

I tried to do following: Num(Score, '(dec)')

and Num#(Score, '(dec)')

But to no avail.

I cannot control how CSV files are generated. Is there a way to overcome this in Qlikview (For example, typecast in Qlikview, etc.)

Thanks

Rahul

[#2]

Hi Guys

Anybody who can help here.

Thanks for your time.

Rahul