Hello,

I want to read a txt file, extract some of the fields and insert that in d/b.

Problem- my txt file does not have a fomat, all I know is I want to extract row 29 from col 6to 9. I am using C#.net for this.

Thanks in advance,
-A

use a readline down to row 29, then however your columns are delimited, read 6 through 9

what piece are you having trouble with, please post the code

use a readline down to row 29, then however your columns are delimited, read 6 through 9

what piece are you having trouble with, please post the code

    StreamReader reader = File.OpenText("C:\\test.txt");  
    string line = reader.ReadLine();           

        while (line != null)
        {

            // string[] stationtxt = line.Split('\t');

            string name = line.Split('\t')[0];
            string url = line.Split('\t')[1];
            string desc = line.Split('\t')[2];

            line = reader.ReadLine();
                           TextBox1.Text = url.ToString();

        }

        reader.Close();
        reader.Dispose();

This is just by trial code, but I am not able to figure out how to navigate to row 29 and get col6 to col9 info.
I am a newbee here, so plz exuse if this is too simple.
-Thanks
A

Edited 3 Years Ago by mike_2000_17: Fixed formatting

Please enclose the code in code brackets

int curLine = 0;
while (line != null)
{
curLine++;

if(curLine == 29)
{
//we are on line 29
}

// string[] stationtxt = line.Split('\t');

string name = line.Split('\t')[0];
string url = line.Split('\t')[1];
string desc = line.Split('\t')[2];

line = reader.ReadLine();
TextBox1.Text = url.ToString();

}

i don't know what col6-9 is, you are only showing three columns, but that is how it get the line number

Please enclose the code in code brackets

int curLine = 0;
while (line != null)
{
curLine++;

if(curLine == 29)
{
//we are on line 29
}

// string[] stationtxt = line.Split('\t');

string name = line.Split('\t')[0];
string url = line.Split('\t')[1];
string desc = line.Split('\t')[2];

line = reader.ReadLine();
TextBox1.Text = url.ToString();

}

i don't know what col6-9 is, you are only showing three columns, but that is how it get the line number

Thanks, I figured that out.
Thanks again,
-A

please can you provide me with source code on how to read .txt file using C

thank you

This article has been dead for over six months. Start a new discussion instead.