CsvInputFormatter seems very simplistic in its approach to working out what each field is

[crittag]

The CsvInputFormatter uses a very simplistic method to split directly on the delimiter:

var values = line.Split(_options.CsvDelimiter.ToCharArray());

This means that:

1. delimiter characters are included in the split regardless of whether they are within "..." quoted values
2. "..." quoted values are returned including the outer quotes

In addition to this, if there is double-quoted text within the value (e.g. "hello ""this"" world"), nothing is done in the conversion to resolve this to a single quote.