'000772' had been cut to '772' when i export as CSV in Slices, how to resovle that?

[vito]

on web page is like this:

but when i export as CSV file is like this:

char '00000670' seems to be translate to number.

that column type is varchar(1000) ,i tried translate colume to char in it's Expression like 'cast(active_name AS char)'. the problem still exist.

anybody can help me ? thx.

[Richard Dean]

Are you certain that the export is causing the truncation, and not the app you're viewing the CSV in? For example, LibreOffice will convert 00072 into 72 unless you explicitly set the type of the column to 'text'

[vito]

ya, i got it. the problem is when open CSV by EXCEL, 00072 recognize as a number type.

thank you.

在 2016年10月10日星期一 UTC+8下午8:24:59，Richard Dean写道：