Hello

I export a table/View to a csv file.
The file include a field with a long number (15 digit)
Some time on the exported file the field show as a number and some time as an exp. 9E+14

How can I force to be a number?
Thanks Sorin

Sorin,

It's not possible, at least not directly.
It's NOT an error - it happens when the FLOAT numbers can't be expressed as a fixed point number with less than 16 digits.
The only workaround that I can see is to convert the FLOAT values to DECIMAL values and export it after, but be aware of the possible rounding errors or overflow if the values are too big.

--
Fernando Dias
[Team Elevate]

Às 10:42 de 28/05/2016, Hershcu Sorin escreveu:
> Hello
>
> I export a table/View to a csv file.
> The file include a field with a long number (15 digit)
> Some time on the exported file the field show as a number and some time as an exp. 9E+14
>
> How can I force to be a number?
> Thanks Sorin
>

Hershcu


This may be a silly question but what are you looking at the csv file in? Notepad, Excel or something else?

Roy Lambert

Hi
I open it with Excel.
Sorin

Hershcu

>I open it with Excel.

In that case its most likely Excel that's deciding how to display the number. Have a look in Notepad and see how that looks.

Sometimes, not always, in Excel, it can be the column width being to small that causes it to display numbers in exponent format.

Roy Lambert