Header does not contain Quote, but some fields in row contain Quote, how should I read this kind of CSV about csvhelper

[JoshClose]

Seems to work fine for me with defaults.

void Main()
{
	var s =
		"""
		Header1,Header2,Header3,IntHeader,DecimalHeader,DateTimeHeader
		content1,"content , (i have comma inside) 2","content3",100,100.00,"04/23/2024"
		content2,"content ,,, (many comma inside)","content2",200,200.00,"05/01/2024"
		""";
	var config = new CsvConfiguration(CultureInfo.InvariantCulture)
	{
	};
	using (var reader = new StringReader(s.ToString()))
	using (var csv = new CsvReader(reader, config))
	{
		csv.GetRecords<Foo>().ToList().Dump();
	}
}

public class Foo
{
	public string Header1 { get; set; }
	public string Header2 { get; set; }
	public string Header3 { get; set; }
	public int IntHeader { get; set; }
	public decimal DecimalHeader { get; set; }
	public DateTime DateTimeHeader { get; set; }
}

[Zero-Xiong]

Sign..... really sad! it's not working in my environment.

FYI, my version is 31.0.3

[Zero-Xiong]

I guess maybe the Unicode character inside the actual CSV file.

like below:

[JoshClose]

CsvHelper doesn't care about that. You set the encoding in your TextReader. It'll use whatever delimiter you have set up in the config.