Retrieving data from .txt file

Question

0.00/5 (No votes)

See more:

Hi All
I am working in C# windows application where I have to read a text file where so many rows are there and every field is separated by tab key. Now my job is to find the particular row by a unique first_name string value and show all the related data of the that particular row.

id first_name Last_Name age height address
001 ABC dsfs 12 6.2 dfdfrewfewrewrer
034 sdg dwqdew 32 8.4 wererfwrw
009 dfdf erewr 24 5.8 ewrdrefdrew

so if I select sdg (first_name) related data of the same should select

Posted 6-Mar-12 22:36pm

IndrajitDasgupat

Updated 6-Mar-12 23:18pm

v2

Add a Solution

3 solutions

Solution 1

1. Read the file contents File.ReadAllText
2. split the rows by using String.Replace("\r\n", "$$$").split(new char[]{'$$$'});
3. Now you have an array of string for each row of text file.
4. Split each row string using string.split('\t')
5. You will further get array of strings for each column value.

6. Now if you know the column wise location of your key string i.e [0] you can device carefully nested foreach statements do perform these splits and search.

Hope it will give you some idea.

Posted 6-Mar-12 22:43pm

Rahul Rajat Singh

Solution 2

Hi,

you could read in the whole text with

C#

System.IO.File.ReadAllText(@"PATH");

then proof if your search term has found and take the whole line.

But I'm asking me why you don't use xml schema for such a case?

Best Regards

Posted 6-Mar-12 22:47pm

El_Codero

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2012-03-06T22:51:00

Solution 3

There are a lot of different ways to do this, but the simplest is probably to read the text into an array of strings, and compare the IDs:

C#

string[] lines = File.ReadAllLines(@"D:\Temp\MyList.txt");
string match = "0321\t";
string wholeLine = "";
foreach (string line in lines)
    {
    if (line.StartsWith(match))
        {
        wholeLine = line;
        break;
        }
    }

Posted 6-Mar-12 22:51pm

OriginalGriff

Comments

IndrajitDasgupat 7-Mar-12 5:15am

if it is selecting with first name which is unique then how can I do

OriginalGriff 7-Mar-12 5:23am

Sorry?
If I understand you correctly, then see the "\t" on the end of the match string? That is the tab character, so the StartsWith needs to match the whole string, including the tab.
If I don't, then please try to explain in more detail.

IndrajitDasgupat 7-Mar-12 5:50am

Sir I got it by using IndexOf
if(line.IndexOf(match)!=-1)
{
}
thanks for giving valuable hints