topic Re: Double qoutes in my extraction file in QlikView

Double qoutes in my extraction file

Thu, 11 Apr 2013 16:05:20 GMT

Hello,

I would like generating an extraction file as following:

'titi','tartanpion','30.9',....

All fields have to enclosed with single quotes.

So i try to concatenante fields with fonction chr(39):

chr(39) & field1 & chr(39),

chr(39) & field & chr(39), ...

But the result is:

" 'titi' "," 'tartanpion' ", .....

Qliview generate double quotes ?

I don't want double quotes but just single quote for each field.

Could you help? Thank a lot.

Best regards.

Re: Double qoutes in my extraction file

Thu, 11 Apr 2013 18:24:47 GMT

Hi,

Your way of doing is correct and it also gives the correct answer with single quote.

But the Double Quote which are getting here are due to the concatenating the ","(Comma) with the field Names .

Please verify are you doing any stuff while concatenating the Comma with Field Names.

If there is anything please let me know.

Re: Double qoutes in my extraction file

Fri, 12 Apr 2013 07:47:15 GMT

Hi ,

Thanks a lot for your return.

In fact I don’t concatenate fields with comma.

See below my instructions:

Extraction_Faits_ventes_total:NoConcatenate

load
CHR(39) & PS$ & CHR(39) as PS$,
CHR(39) & INVOICE_ID$ & CHR(39) as INVOICE_ID$,

……….

RESIDENT Extraction_Faits_ventes_total_TMP;

STORE Extraction_Faits_ventes_total into $(Dir_Export)\$(file_name) (ansi, txt, delimiter is ',');

The result is :

"'FR_SQL'","'0008497752'", ……

but I just want that:

'FR_SQL','0008497752', …..

Thanks for your help

Regards,

Re: Double qoutes in my extraction file

Fri, 12 Apr 2013 07:51:43 GMT

Hi ,

Thanks a lot for your return.

In fact I don’t concatenate fields with comma.

See below my instructions:

Extraction_Faits_ventes_total:

NoConcatenate

load

CHR(39) & PS$ & CHR(39) as PS$,

CHR(39) & INVOICE_ID$ & CHR(39) as INVOICE_ID$,

……….

RESIDENT Extraction_Faits_ventes_total_TMP;

STORE Extraction_Faits_ventes_total into $(Dir_Export)\$(file_name) (ansi, txt, delimiter is ',');

The result is :

"'FR_SQL'","'0008497752'", ……

but I just want that:

'FR_SQL','0008497752', …..

Thanks for your help

Regards,

Rodolphe.

De : yusuf.ali

Envoyé : jeudi 11 avril 2013 20:25

À : Delsart, Rodolphe

Objet : - Re: Double qoutes in my extraction file

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Double qoutes in my extraction file

created by yusuf.ali<http://community.qlik.com/people/yusuf.ali> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/334778#334778>

Re: Double qoutes in my extraction file

Sat, 13 Apr 2013 17:38:35 GMT

Hi ,

The Addition of Double Quotes in NotePad is due to the Notepad configurations set up.

As per my knowledge It is not a QlikView Bug .

I hope there should be way using macro we can remove double quotes.

Thanks

Re: Double qoutes in my extraction file

stevedark — Thu, 16 Jan 2014 16:32:48 GMT

Did anyone find an answer to this one? In the past I have got around the problem by doing the store with a FileSystemObject write in a macro - but I've another case come up when I would much rather use a store on load.

Any suggestions welcome!

Steve

Re: Double qoutes in my extraction file

Mon, 30 Jan 2017 18:03:01 GMT

Steve, apparently there is no answer. I have searched for 3 days to try an eliminate the "default" Qlikview double quote issue.

Most posts drift off into some other issue or drop off with no conclusion.

Seems like a really common issue. I'm surprised more people haven't asked Qlik for a resolution.

Re: Double qoutes in my extraction file

stevedark — Mon, 30 Jan 2017 20:14:55 GMT

Thanks for the input David - that was the conclusion I came to. It means I have to put up with slightly dodgy HTML code in my output.

To see what I was looking to achieve with the STORE see the publishing to web example at the foot of this blog post:

https://www.quickintelligence.co.uk/write-csv-qlikview-store/

Steve