How to change text data to number in qvw?

[#1]

HI,

I have data as below in chart.

437583804734805834

64732456045720483

9084323783034810238147

when I am sending data to csv the numbers are showing as below

4.37583E+14

6.47325E+13

4.08432E+17

how to change the csv general format into number. I have used Number under format cells. when I used format cells the data is showing as below

437583804734805830

64732456045720480

9084323783034810238140

Please can anyone suggest me is there any way to set this into correct number format.

Thanks.

[MK_QSL · Accepted solution]

Data:

LOAD ID,

  IF(Len(PurgeChar(StageData,'0123456789'))=0,Evaluate(StageData),StageData) as StageData

FROM

Test.xls

(biff, embedded labels, table is Sheet1$);

[#3]

Thanks. I have used this. still showing same.

[MK_QSL]

I have checked in my computer and not showing any error.

Your StageData is a mixture of Text/String and Numbers so I have converted Numbers which are more than 14 digit as numbers and rest need to be kept as String !

[#5]

I have checked by sending to excel one into csv and one into excel worksheet 97 - 2003. when sending to csv same problem occurring. when I send to excel worksheet the data is loading fine. but each sheet is loading only to 65536 rows and splitting into 4 sheets. Is there any way I can get all data fit into one excel sheet with the help of qvw?

[MK_QSL]

If rows are more than 65536, file will automatically converted to CSV..

I don't have idea how to use 4 sheets but may be an EXCEL MACRO can help you.

[sasiparupudi1]

I think your problem is more an excel issue than Qlikview. Please see below article

https://support.microsoft.com/en-us/kb/2643223

[#8]

Thanks.