How to parse a .txt file in C#

[nithin.papdeja]

Hi all,

I have to parse a .txt file and retrieve only "Name" from second
column and store it in a list

My text file is of this format:

Bit Name Description
-1 Lucky groupa
-1 Roy groupb

In the list i should have only "Lucky" and "Roy" and nothing else.

I am very new to C# can anyone please tellme how i can do this

thanks for help,
Nithin
I

[Mythran]

<ni************ @gmail.comwrote in message
news:b1******** *************** ***********@x16 g2000prn.google groups.com...

Hi all,

I have to parse a .txt file and retrieve only "Name" from second
column and store it in a list

My text file is of this format:

Bit Name Description
-1 Lucky groupa
-1 Roy groupb

In the list i should have only "Lucky" and "Roy" and nothing else.

I am very new to C# can anyone please tellme how i can do this

thanks for help,
Nithin
I

This is actually pretty simple depending, but we need a little more
information. Is Bit always a -1 or a 0 or...always an integral value? Is
Name always a single word? Is Name ever surrounded with quotes? Could
there be any types of delimiters besides a space?

From the simple example you gave, you simply have 3 columns delimited by a
space...:

If you are using .Net 3.5, you can make use of anonymous types and LINQ
(note, I know this is definitely not the most efficient block of code in the
world, but hey, it works :)

string[] lines = File.ReadAllLin es(@"C:\input.t xt");
int i = 0;
var items =
from line in lines
where i++ != 0
select new {
Bit = line.Split(new char[] { ' ' }, 3)[0],
Name = line.Split(new char[] { ' ' }, 3)[1],
Description = line.Split(new char[] { ' ' }, 3)[2]
};

foreach (var item in items) {
Console.WriteLi ne(
"Bit: {0}, Name: {1}, Description: {2}",
item.Bit,
item.Name,
item.Descriptio n
);
}

// The following can be used in version 2.0 and does not make use of
anonymous types nor LINQ:

string[] lines = File.ReadAllLin es(@"C:\input.t xt");
int i = 0;

foreach (string line in lines) {
if (i++ == 0) continue;

string[] items = line.Split(new char[] { ' ' }, 3);
Console.WriteLi ne(
"Bit: {0}, Name: {1}, Description: {2}",
items[0], items[1], items[2]
);
}
HTH,
Mythran

[Cowboy \(Gregory A. Beamer\)]

StreamReader reader = new StreamReader(fi lePath);
string line;

//Assume that is a tab, if space change to " ".ToCharArr ay()
char[] splitChar = "\t".ToCharArra y();

while(null != (line = reader.ReadLine ))
{
string[] split = line.Split(spli tChar);

int bit= int.Parse(split[0]);
string name = split[1];
string description = split[2];

//Do something with parse here?
}

reader.Dispose( );

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

*************** *************** **************
| Think outside the box! |
*************** *************** **************
<ni************ @gmail.comwrote in message
news:b1******** *************** ***********@x16 g2000prn.google groups.com...

Hi all,

I have to parse a .txt file and retrieve only "Name" from second
column and store it in a list

My text file is of this format:

Bit Name Description
-1 Lucky groupa
-1 Roy groupb

In the list i should have only "Lucky" and "Roy" and nothing else.

I am very new to C# can anyone please tellme how i can do this

thanks for help,
Nithin
I