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]

Test:

Load Evaluate(NumberField) as NumberField Inline

[

  NumberField

  437583804734805834

  64732456045720483

  9084323783034810238147

];

Evaluate() Function

[#3]

Thanks. I have checked Evaluate() function which you added in reply. Actually I have the above mentioned data in column StageData. the column StageDate have values more than 90,000 rows. how can I use Evaluate () function in column StageData. Please let me know.

[MK_QSL]

Use below in your script...

Evaluate(YourFieldName) as YourNewFieldName

[robert_mika]

Perhaps:

Evaluate(StageDate) as Stagedata

[#6]

sorry I should have mention earlier reply. I have used Evaluate on column name as below earlier.

Evaluate(StageDate) as Stagedata

when I used this and reload showing execution of script failed.

[PrashantSangle]

Hi,

I dont think so your script is failing because of Evaluate()

First Debug your script and also generate Document log where you find reason for script failure.

Regards

[#8]

I checked the log file . showing below messages

General Script Error

Execution failed

[MK_QSL]

Share you QVW please!

[#10]

Please see attached.