topic Re: Keep leading zeros when saving to CSV in QlikView

Keep leading zeros when saving to CSV

Tue, 29 Oct 2013 07:20:20 GMT

Hi,

I have text field (Kostenplaats) which in some cases contains leading zero. I wrap the field in TEXT() function and the Qlikview shows it correctly in Qlikview. However when I store the resident to CSV, Qlikview drops the leading zero and perceives the field as a number.

FOR EACH vBatch in $(vBatchList)
  exportFactuurBatch:
  Load
  Datum, 
  TEXT(IF (labelId =1 , '08 ', '608'))        AS Kostenplaats,
  'D' AS Accounttype
resident Inputfile
WHERE Batch = '$(vBatch)'
;


  LET vOutputFile = 'Webshopgiftcard Factuur Batch '&  '$(vBatch)' & '.csv';

  // store output file in intermidiate server location
  store * fro
m exportFactuurBatch into [$(AfasOutputLocation)\$(vOutputFile)] (txt,  delimiter is ';') ;

output:

This should be easy, right?

Dror

Re: Keep leading zeros when saving to CSV

Gysbert_Wassenaar — Tue, 29 Oct 2013 08:18:28 GMT

Did you open the csv file in Excel of in a text editor? If it's Excel it's possible Excel is interpreting the text as numbers and dropping the leading 0.

Re: Keep leading zeros when saving to CSV

Tue, 29 Oct 2013 11:14:59 GMT

In both. Both are dropping the leading zero's

Re: Keep leading zeros when saving to CSV

Gysbert_Wassenaar — Tue, 29 Oct 2013 11:21:24 GMT

I can't reproduce this. The leading zero and the trailing space are preserved in the csv file here. Can you post an example file that reproduces the issue?

Re: Keep leading zeros when saving to CSV

vamsee — Thu, 06 Apr 2017 14:11:40 GMT

Hi,

I was just working on a similar issue. You might have found the way, but for people with similar issues.

Store CSV file using semicolon instead of colon

It is a feature of excel to trim the zeros when uploaded from a different source. Sadly we cannot change that feature.

But if one reads the same file again back into Qlik the preceeding Zero's come in.