Importing a TXT file to a DataTable so it matches how Excel imports it - C# .NET

Question

I have a txt file, and I can import it into Excel with the following settings perfectly:

Type: Delimited

Delimiters: TAB

Text Qualifier: None

I tried loading it into a DataTable by reading the input file into a String[] array, and then splitting that String[] array.

However how do you represent a TAB when splitting a string? Is this even possible?

How can I import my TAB delimited txt file into a DataTable? If it were comma separated I think my code would work, but not a clue how to represent a TAB?...

Any ideas or code samples showing how to do this?

Any help greatly appreciated.

Dan

score 1 · Accepted Answer · answered Sep 02 '10 at 20:32

Just use '\t' for a tab.

So something like this would probably work (though I might be mixing up VB.Net and C# syntax right now):

string rows[]; // read in file here
foreach(string row in rows)
{
     string values[] = row.Split('\t');
     foreach(string value in values)
     {
          // do something
     }
 }

score 0 · Answer 2 · answered Sep 02 '10 at 20:38

0

We are tool using apes. I'm just sayin'

answered Sep 02 '10 at 20:38

Wyatt Barnett

15,500
3
32
52

score 0 · Answer 3 · edited May 23 '17 at 10:30

0

I have found the answer to this here:

Efficient function for reading a delimited file into DataTable

Sorry for creating something similar. Should have searched more thoroughly.

edited May 23 '17 at 10:30

Community

1
1

answered Sep 02 '10 at 20:39

Dan Harris

1,340
1
20
43

Importing a TXT file to a DataTable so it matches how Excel imports it - C# .NET

3 Answers3