将值转换为整型

Question

我正在尝试使用CsvHelper从CSV文件转换值。值本身是一个整数，但csv中的值包含一个空格，例如"0 "或者"12 "

我现在怎样才能使它工作呢?在StackOverFlow上我发现了这个线程，但是修剪并不适用于绑定。根据这个库的创建者的注释，它应该从V2.9.0开始。

如何忽略空白时使用CsvHelper, CsvReader.Read()?

我试着这样读取我的CSV:

using (TextReader reader = new StreamReader(datei))
{
CsvConfiguration configuration = new CsvConfiguration(CultureInfo.GetCultureInfo("de-DE"));
configuration.BadDataFound = null;
configuration.TrimOptions = TrimOptions.Trim;

using (var csv = new CsvReader(reader, configuration))
{
ArtikeldatenLieferant = csv.GetRecords<AllnetArtikel>().ToList();
}
}

编辑:

这是导致这个问题的CSV中的一行:

Nr.;ALLNET-Artikelnummer;Hersteller-Artikelnummer;Hersteller;Produktbezeichnung;EAN Nummer;Kategorieebene1;Kategorieebene2;Kategorieebene3;HEK;Artikelzustand;UVP;Produktbeschreibung;Gewicht;Lagerbestand 
9234;193301;AL-MSUC-SUF-S;Audiocodes Live;Audiocodes Live - AL-MSUC-SUF-S;;Telekommunikation;Voice over IP;Voice over IP - Gateway Support;2739,13;neu;3043,48;"AudioCodes Live non-recurring setup fee, for each customer site with up to 500 users. Includes delivery, Planning and Design consulting service, Implementation service (configuration and basic verification) for AudioCodes hardware or software, and cutover support into production for a single event. Does not include Project Management.;0,001;0 

编辑2:这是AllnetArtikel类。

public class AllnetArtikel
{

[Name("Nr.")]
public string Nr { get; set; } = string.Empty;
[Name("ALLNET-Artikelnummer")]
public string AllnetArtiNr{ get; set; } = string.Empty;
[Name("Hersteller-Artikelnummer")]
public string HerstellerArtiNr{ get; set; } = string.Empty;
[Name("Hersteller")]
public string Hersteller{ get; set; } = string.Empty;
[Name("Produktbezeichnung")]
public string Produktbezeichnung{ get; set; } = string.Empty;
[Name("EAN Nummer")]
public string EAN{ get; set; } = string.Empty;
[Name("Kategorieebene1")]
public string Kategorie1{ get; set; } = string.Empty;
[Name("Kategorieebene2")]
public string Kategorie2{ get; set; } = string.Empty;
[Name("Kategorieebene3")]
public string Kategorie3{ get; set; } = string.Empty;
[Name("HEK")]
public decimal HEK{ get; set; }
[Name("Artikelzustand")]
public string Zustand{ get; set; } = string.Empty;
[Name("UVP")]
public decimal UVP{ get; set; }
[Name("Produktbeschreibung")]
public string Produktbeschreibung{ get; set; } = string.Empty;
[Name("Gewicht")]
[Default(-1)]
public decimal Gewicht{ get; set; }
[Name("Lagerbestand")]
public int Lagerbestand { get; set; } 
}

Answer 1

最终更新

问题最终是字段中的引号，引号没有转义或字段包含在引号中。;"AudioCodes ... Management.;。由于报价是所需数据的一部分，因此解决方案是将配置模式更改为NoEscape。此模式将忽略引号和转义字符。

configuration.Mode = CsvMode.NoEscape;

适用于int.Parse的字符串也适用于CsvHelper。例如int.Parse("0 ") == 0。因为有额外的空白不是一个问题，它的工作，当你改变你的整数字段为字符串，我要采取一个猜测，你的问题实际上是一个空值。CsvHelper无法将任何空值转换为int。如果是这种情况，您有两个选择。

将整型字段转换为Nullable<int>

void Main()
{
CsvConfiguration configuration = new CsvConfiguration(CultureInfo.GetCultureInfo("de-DE"));
using (var reader = new StringReader("Id;Namen1;Joen;Jenny"))
using (var csv = new CsvReader(reader, configuration))
{
var records = csv.GetRecords<Foo>().ToList().Dump();
}
}
public class Foo
{
public int? Id { get; set; }
public string Name { get; set; }
}

或者给你的整型字段一个默认值

void Main()
{
CsvConfiguration configuration = new CsvConfiguration(CultureInfo.GetCultureInfo("de-DE"));
using (var reader = new StringReader("Id;Namen1;Joen;Jenny"))
using (var csv = new CsvReader(reader, configuration))
{
var records = csv.GetRecords<Foo>().ToList().Dump();
}
}
public class Foo
{
[Default(0)]
public int Id { get; set; }
public string Name { get; set; }
}

原来

你确定你没有得到其他东西的异常吗?我可以在数字后面加上任意多的空格，它仍然可以正确读取。

void Main()
{
CsvConfiguration configuration = new CsvConfiguration(CultureInfo.GetCultureInfo("de-DE"));

using (var reader = new StringReader("Id;Namen1    ;Joen10 ;Jenny"))
using (var csv = new CsvReader(reader, configuration))
{
var records = csv.GetRecords<Foo>().ToList();
}   
}
public class Foo
{
public int Id { get; set; }
public string Name { get; set; }
}