topic Re: Store in CSV without double quotes in QlikView

Store in CSV without double quotes

Tue, 04 Mar 2014 16:44:11 GMT

Hi,

I have a script which ends by storing formated data in a csv file (delimiter ';') that can later be uploaded in SAP. This is for a recurring job I'd like to get fully automated. It all works fine except that the final csv file contains double quotes around a field. This field is a long text containing a simple quote, which I insert as &chr(39)& in the concatenation.

But then, whether I make

store * from ExportCSV into ExportCSV.csv (txt, utf8, delimiter is ';')

store * from ExportCSV into ExportCSV.csv (txt, utf8, delimiter is ';', no quotes)

I get those double quotes.

Is there a way to overcome this? Or is there other ways, like using a macro to clear the double quotes in the csv afterwards ?

Many thanks in advance.

Re: Store in CSV without double quotes

giakoum — Tue, 04 Mar 2014 16:53:41 GMT

I tried it and it works correctly for me (see attached)

or maybe I misunderstood...

Re: Store in CSV without double quotes

Tue, 04 Mar 2014 17:46:31 GMT

After more tests, it turned out it's due to a simple quote in this field. I edited original post.

But that's the way this field should be, and without the double quotes when I store it. Is there a trick to deal with this?

Re: Store in CSV without double quotes

srchilukoori — Tue, 04 Mar 2014 17:46:36 GMT

This seems to work for me, can you upload a sample set of data to test it.

Thanks,

Re: Store in CSV without double quotes

jaimeaguilar — Tue, 04 Mar 2014 17:47:37 GMT

Hi, I tested Ioannis Giakoumakis example and it works, however, your issue could be with something else, could you upload a sample of your data please?

regards

Re: Store in CSV without double quotes

Tue, 04 Mar 2014 18:03:58 GMT

Thanks for your answers. Problem appears exactly when I add a text field containing a simple quote, example in attached.

Re: Store in CSV without double quotes

srchilukoori — Tue, 04 Mar 2014 18:41:25 GMT

Single and double quotes are part of Qlikview's reserve literals to identify strings. That is the reason why it adds double quotes to your csv file.

Re: Store in CSV without double quotes

Tue, 04 Mar 2014 18:52:11 GMT

OK. Is there any way to get the csv rid of double quotes automatically after this?

Re: Store in CSV without double quotes

jaimeaguilar — Tue, 04 Mar 2014 19:01:13 GMT

maybe using purgechar() before exporting to csv

Re: Store in CSV without double quotes

Tue, 04 Mar 2014 19:07:36 GMT

This field is meant to be transmitted to SAP in the end with the simple quote. Is there a way through a QV macro to either clean the csv or add the quote in csv afterwards?

Re: Store in CSV without double quotes

Tue, 13 May 2014 09:49:28 GMT

I have the same problem - even worse, the contents of every field that contains a string must be enclosed in double quotes.

Fortunately, I do not need to automate the export. What I did is this:

- Prepare the table in the Script

- Have a table box that contains the table

- Klick on the "Send to Excel" icon in the table box's title bar

- select the required columns in excel, Copy and Paste into an editor, Save.

I ended up adding a "RecNo" column to my table, sorting according to it in the table box and leaving it out when copying in Excel. Without that, the order in the Excel export seemed to be unpredictable.

HTH, Frank

Re: Store in CSV without double quotes

lalitinmbd — Wed, 14 May 2014 09:32:32 GMT

Any Ideas How to resolve this problem??

Re: Store in CSV without double quotes

lalitinmbd — Wed, 14 May 2014 09:45:40 GMT

How can we avoid these double quotes as the file needs to be used in a separate system.??

Re: Store in CSV without double quotes

Anonymous — Wed, 17 Oct 2018 11:44:21 GMT

I have seen looking around many post the same issue since 2013 and I really feeling shocking that qlik has not declare an oficial solution. I have the same issue and this issue has generated several questioning around my company to prospect to migrate a qlik environment. Another developer is just working now in an PHP cron that solve the problem. Quotes 1, QLIK 0.

Regards

Re: Store in CSV without double quotes

tomasz_tru — Wed, 31 Oct 2018 14:38:46 GMT

Have you tried some kind of 'exotic' delimiter like '&'?

Tomasz

Re: Store in CSV without double quotes

quaresmar — Fri, 29 Apr 2022 18:33:17 GMT

This way worked for me.

LET vDoubleQuote = Chr(10);

NoConcatenate
FACTS:
LOAD
CRM_CODE,
'$(vDoubleQuote)'&ProductPackName&'$(vDoubleQuote)' as ProductPack,
'$(vDoubleQuote)'&'SELLOUT'&'$(vDoubleQuote)' as METRIC,
'$(vDoubleQuote)'&left(cod_date_operation,4)&'$(vDoubleQuote)' as Year,
'$(vDoubleQuote)'&right(cod_date_operation,2)&'$(vDoubleQuote)' as Month,

If(IsNull(#SellOut_Units),0,#SellOut_Units) as VALUE
Resident FactsTransact;

STORE FACTS into Facts.csv (txt, delimiter is '|');