开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜