CSVHelper does not parse my Tab delimited CSV file

Question

I am trying to read a tab delimited CSV file and parse it with CSVHelper.

I have the following :

 _reader = new StreamReader(_stream);
 _csvReader = new CsvReader(_reader);
 _csvReader.Configuration.Delimiter = "\t";

but the reader fails to recognize and parse the file correctly

Any ideas ?
What are the possible delimiters with CSVHelper ?

score 14 · Accepted Answer · answered Mar 01 '20 at 12:40

14

So for some reason, it turns out that it works only when I do the following:

 _reader = new StreamReader(_stream);

 CsvHelper.Configuration.Configuration myConfig = new 
     CsvHelper.Configuration.Configuration();

 _csvReader.Configuration.Delimiter = "\t";

 _csvReader = new CsvReader(_reader, myConfig);

answered Mar 01 '20 at 12:40

Danielle

3,324
2
18
31

I only found CsvConfiguration instead of Configuration() like this `CsvHelper.Configuration.CsvConfiguration()` – Stu_Dent Jul 11 '21 at 05:52
This answer is incorrect. There is no class called `CsvHelper.Configuration.Configuration`. – user366312 Jan 26 '23 at 00:55

score 1 · Answer 2 · answered Aug 15 '22 at 18:26

Digging though the source code there is a Delimiter parameter. The code below worked for me.

var config = new CsvConfiguration(CultureInfo.CurrentCulture) { Delimiter = "~" };
using var csv = new CsvReader(reader, config);

source: https://github.com/JoshClose/CsvHelper/blob/master/src/CsvHelper/Configuration/CsvConfiguration.cs

score 0 · Answer 3 · answered Jan 31 '21 at 01:15

I encountered a similar problem parsing a tab delimited file in vb, didn't work for me until I replaced "\t" with vbTab

My code:

Imports System.Globalization
Imports System.IO
Imports CsvHelper
Imports CsvHelper.Configuration
Imports CsvHelper.Configuration.Attributes

Public Class TabDelimetedReader
    Public Shared Function ReadFile(path As String) As IEnumerable(Of TabFileDefinition)

        Dim config = New CsvConfiguration(CultureInfo.InvariantCulture,
            hasHeaderRecord:=False,
            delimiter:=vbTab)

        Using reader As StreamReader = New StreamReader(path)
            Using tsv = New CsvReader(reader, config)
                Return tsv.GetRecords(Of TabFileDefinition).ToList
            End Using
        End Using

    End Function
End Class

score 0 · Answer 4 · edited Mar 04 '21 at 23:04

0

I ran into similar issue with a tab delimited file- and I could not get Delimiter = "\t" to work...

Then I added Encoding = Encoding.UTF8 in the configuration, then it worked!

edited Mar 04 '21 at 23:04

Rishabh Kumar

2,342
3
13
23

answered Mar 04 '21 at 18:11

GBCode

1

1

Hi, could you provide the exact code, that could make your answer more awesome. – Rishabh Kumar Mar 04 '21 at 18:56

score 0 · Answer 5 · answered Feb 22 '23 at 10:20

Update on the original answer.

(posting as a new answer as the original answer is not editable for some reason)

The original answer was of course correct. Later, the CsvHelper API has slightly changed. Here is a code for current CsvHelper version (30.0.1):


var _reader = new StreamReader(_stream);

CsvHelper.Configuration.CsvConfiguration myConfig = new
    CsvHelper.Configuration.CsvConfiguration(CultureInfo.InvariantCulture)
    {
        Delimiter = "\t"
    };

var _csvReader = new CsvReader(_reader, myConfig);

CSVHelper does not parse my Tab delimited CSV file

5 Answers5

Linked