Export to csv issue

[#1]

dear all,

when i export data from Qlikview application to abc.csv its remove zero or zero's from the start of text or number type columns for example,

value is 0123456 its show in csv 123456 or 001234 its show 1234 or 0001234 its how 1234.

kindly guide how to resolve this.

Regards,

Zain.

[quwok]

Excel is being intelligent and identified the column as number and hence formatted it as a number which drops preceding zeros.

The same thing happens in QlikView, hence the use of text() to force the data type on the field.

[sasiparupudi1]

can you post a sample of your data

[sasiparupudi1]

Instead of double clicking on the csv file to open in excel, do the following

open excel

go to data tab, select from text file option

manually specify the delimeter

and change the number column to text.

hth

Sasi

[#5]

Thanks dear Sasidar for time and replies, i have got it results, i did export to csv and fetch data into access and also data in excel.

Regards,

Zain.

[sasiparupudi1]

Great, please close this thread by marking your resolution, thanks

Sasi