开发者

Undesirable Double Quotes When Exporting a Tab Delimited File

开发者 https://www.devze.com 2023-03-19 14:15 出处:网络
When I export my SQL results into a tab delimited file, double quotes surround ahandful of my records. I don\'t know why this is. I am assuming it is because some of the record names have a special ch

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

精彩评论

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