Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sijojoseph22
Creator II
Creator II

Double Quotes while writing to TXT file

Hi All,

We are writing a table into txt file using the store command. e.g store ExtractofAddress into  0002 - Addresses.txt(txt); This is working fine.

But when if the value contains comma (','), the the value is starting and ending with double quotes (' " '). We want the data without double quotes.

Is there any solution for this ?

Attached the sample qvw

Thanks,

Sijo

9 Replies
tamilarasu
Champion
Champion

Try like below,

Store Name into test.txt (txt, codepage is 1252, no labels, delimiter is '\t', no quotes);

Ignore the red line in script window.

sunny_talwar

May be store like this:

Store Name into test.txt(txt, delimiter is '|')'

sijojoseph22
Creator II
Creator II
Author

Thanks

This is working for comma, but I got double quotes for  " ' ". Is there any way we can avoid double quotes coming due to special character.

tamilarasu
Champion
Champion

This is working fine in my test data. Could you post some sample file, so that we can check.?

sijojoseph22
Creator II
Creator II
Author

Please find the below sample data

 

Name
Arun Sane
Prasant,Saha
Vika's Taunk
Dixon$ Devassy
John Honnai*

Thanks,

Sijo

swuehl
MVP
MVP

Yes, that's a known limitation.

You can vote for some ideas like

sijojoseph22
Creator II
Creator II
Author

Thanks Sunny.

sijojoseph22
Creator II
Creator II
Author

Thanks