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

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

Thu, 21 Apr 2011 15:53:56 GMT

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

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

Thu, 21 Apr 2011 16:30:19 GMT

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.