Undesirable Double Quotes When Exporting a Tab Delimited File
When I export my SQL results into a tab delimited file, double quotes surround a handful of my records. I don't know why this is. I am assuming it is because some of the record names have a special character breaking something?
A simple solution would开发者_如何学Python be to go in and do a find and replace on double quotes, but that seems a bit improper.
I encountered this with fields that contained commas, even when loading a tab delimited file. A field qualifier and "Always Qualify Fields" prevented the fields with commas being quoted in the DB.
精彩评论