Read CSV text file

krishnakumar kuna

Hello,
I am new to asp.net c# were i need to develop a website which accept the text file by file upload ,were the text file will be looking like this

eg:

one,two,three,four,five,six,seven,eight,nine,ten
one,two,three,four,five,six,seven,eight,nine,ten
one,two,three,four,five,six,seven,eight,nine,ten
one,two,three,four,five,six,seven,eight,nine,ten
one,two,three,four,five,six,seven,eight,nine,ten
which has 5 rows and 10 column which is separate by comma delimiter and i need to read the string into the mysql database but before that i need to read those value into string array and .
now the problem is i need only certain values for example

eg:

one,four,seven,ten
one,four,seven,ten
one,four,seven,ten
one,four,seven,ten
one,four,seven,ten

in here i only need one four seven and ten column value or string from every row.
I need coding to do this process.

thank you in advance.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kunal Vaishya13y ago
Accepted answer
Try this type.

string fileName = @"C:\Text.csv";
string s;
string str = string.Empty;
if (File.Exists(fileName))
{
StreamReader sr = new StreamReader(fileName);
String line;
while ((line = sr.ReadLine()) != null)
{
if (line.Trim() != string.Empty)
{
//You will get Text Line in s.
s = line ;

string[] linetex;
linetex = s.Split(',');
for(int i=0; i<= linetex.Lenght -1 ;i++)
{
string item ;
item =linetex[i];
}
}
}
}
else
{
s = "File does not exists";
}
return s;
0
krishnakumar kuna13y ago
Thank you
0
Kunal Vaishya13y ago
yes dear , if any issue let me know
0
krishnakumar kuna13y ago
thank you for your answer kunal ,it's great and i have some doubt,

1. is the string item is array?

2. how can get the 1,5,9th string alone

is this correct
firstvalue=item[1];
fifthvalue=item[5];
ninthvalue=item[9];

thanks in advance
0