Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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.