Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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,
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.
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>
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
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
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.
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