Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple double quote (char(034)) when Export Table into a file with Tab separator

Hi,

In my table, I've got some data with one " (double quote) at the beginning, and another at the end. I want to export this table into a file, format *.txt, separator = Tab. The result is that in the file, I have 3 double quote instead of one ! I tried different option, the reult is the same.

example :

"123456" | abcd | "123456" in QV

"""123456""" <tab> abcd <tab> """123456""" in my File.

Thanks in advance for your help

1 Reply
Not applicable
Author

I've actually tried many, many different things and never found a way to make this work so I would love to know this as well. I've tried chr(34) (or whatever it is) and that didn't work either. I also tried exporting to txt from a vba macro in Excel and that did the same weird thing with the quotes so... I clearly don't understand what's going on here either.