FileHelpers：在不带引号的CSV可选字段 [英] FileHelpers: Optional fields in non-quoted CSV

问题描述

我使用 FileHelpers 从CSV文件导入数据。问题是，CSV文件的一些版本有比别人更多的领域。

I am using FileHelpers to import data from a CSV file. Problem is, some versions of the CSV file have more fields than others.

因此，我也标志着有时缺少为可选字段，但这并不似乎工作作为替代，当字段缺失（它似乎做OK）它也总是砍的最后一个字符关闭最后一个字段是存在的只是忽略了。

As such, I have marked the fields that are sometimes missing as being optional, but this does not seem to work as instead of just ignoring when fields are missing (which it seems to do ok) it is also always chopping the last character off of the last field that is present.

例如...

• 包含一排ABC，DEF，GHI（不带引号）作为进口ABC， DEF&放大器; GHI


• 包含ABC，DEF（同样不带引号）行作为进口ABC和安培; DE

我的记录格式定义如下...

My record format is defined as follows...

[DelimitedRecord(@",")]
public class RecordFormat {

    [FieldTrim(TrimMode.Both)]
    public String FirstValue;

    [FieldTrim(TrimMode.Both)]
    public String SecondValue;

    [FieldOptional]
    [FieldTrim(TrimMode.Both)]
    public String OptionalValue;

}

能否有人认为它是什么，我缺少什么？

Can anybody suggest what it is I am missing?

感谢。

推荐答案

看起来像一个错误，这似乎是固定的在最新版本2.9.9

Look like a bug in which seems to be fixed in the latest version 2.9.9

请参阅链接 HTTP ：//www.filehelpers.com/forums/

这篇关于FileHelpers：在不带引号的CSV可选字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！