问comma文件输入步骤-用逗号分隔符

EN

我有奇怪的问题，五旬节6.1CSV文件输入步骤。

我在CSV文件中有以下值：

"2016-09-16"，“测试，S.L."，”测试“，"test",39.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000

我在CSV文件输入步骤中使用：

Delimiter: ,
Enclosure: "

预览选项运行良好，但当我试图将该内容导入数据库表并执行转换时，我将得到以下错误：

2016/09/23 22:46-写日志0- 2016/09/23 22:04:46 -写信给log.0 - 2016/09/23 :04:46-在org.pentaho.di.core.row.value.ValueMetaBase.convertStringToNumber(ValueMetaBase.java:803) 2016/09/23 22:04:46 -在org.pentaho.di.core.row.value.ValueMetaBase.getNumber(ValueMetaBase.java上给log.0写:1631) 2016/09/23 22:46-写入log.0 -再写7次2016/09/23 22:46-写入log.0 -由于: org.pentaho.di.core.exception.KettleValueException: 2016/09/23 22:04:46 -写到log.0 -请求字符串:无法将字符串转换为数字:在1位置找到的非数字字符表示值[S.L."，“测试”，"test",38.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000

我假设它在下面的值"test，S.L.“中有问题。(第5栏)。我不明白为什么，因为预览选项有效。