CVS文件中的双倍双重报价 [英] Double Double quote in CVS file

问题描述

您好

我正在尝试复制数据CSV文件，其中一些行的格式为"超级"，"豪华"和"豪华"。卡车" 这应该全部放入一列，但是，ADF读取它属于两列。 

我已在引号char中指定为  "但是它没有按预期工作。 

理想情况下，我希望避免在CSV文件中编辑任何内容。有没有办法在ADF中解决这个问题？

谢谢

解决方案

你好，

你设置了哪个列分隔符？我创建了一个包含以下内容的文件：
" Super，"" luxury"" truck"，将列分隔符设置为，（逗号） 并引用char作为" （双引号），点击预览，它只返回一列。您能否提供一份完整的样本数据，您使用的是
？ 

Hi there 

I am trying to copy data from a CSV file where some of the rows are in format "Super, ""luxurious"" truck"  which should all go into one column, however, ADF reads it as it belongs to two columns. 

I have specified in the quote char as  ", however it is not working as intended. 

Ideally I would want to avoid editing anything in the CSV file. Is there any way to get around this in ADF?

Thanks

解决方案

Hi there,

what column delimiter did you set? I create a file with content: "Super, ""luxurious"" truck", set column delimiter as , (comma)  and quote char as " (double quote), click preview, it returned only one column. Would you please provide a piece of complete sample data you were using? 

这篇关于CVS文件中的双倍双重报价的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！