Search value in csv file using c#

Question

I have a csv file named file.csv which contains data as follow

Id   Name     Address   Contact
 1   Peter    USA       12345
 2   Anna     UK        45678
 3   John     USA       9876

I want to search for the Name using c# and return the value from the Address. For eg. If the user searc for Peter then, USA should be returned.

Can anyone give me some idea?

Answer 1

I suggest you to create some class to hold this data:

public class Person
{
   public int Id { get; set; }
   public string Name { get; set; }
   public string Address { get; set; }
   public string Contact { get; set; }
}

Then read people from your file:

var person = File.ReadLines("file.csv").Skip(1)
                 .Select(ParsePersonFromLine)
                 .Where(p => p.Name == "Peter")
                 .FirstOrDefault();

if (person != null)
   // use person.Address

Parsing of person can look like:

private static Person ParsePersonFromLine(string line)
{
    string[] parts = line.Split(',');
    return new Person {
        Id = Int32.Parse(parts[0]),
        Name = parts[1],
        Address = parts[2],
        Contact = parts[3]
    };
}

Answer 2

You can create a function to do this task as below:

String GetAddress(String searchName)
{       
   var strLines=File.ReadLines("filepath.csv");
   foreach(var line in strLines)
   {
      if(line.Split(',')[1].Equals(searchName))
         return line.Split(',')[2];
   }

   return "";
}

you can call the above function as below:

String peterAddress=GetAddress("Peter");

EDIT:

        String address="";
        Dictionary<String, String> dict_Name_Address = new Dictionary<string, string>();
        var lines=File.ReadLines("FileName.csv");
        foreach (var line in lines)
        {
            dict_Name_Address.Add(line.Split(',')[1],line.Split(',')[2]);
        }
        if(dict_Name_Address.ContainsKey(searchKey))
         address = dict_Name_Address[searchKey];

Answer 3

If your file is well-formatted this should work.

var values = File.ReadLines("file.csv")
                 .Skip(1)
                 .Select(line => line.Split(','))
                 .ToList();

var address = values.Where(x => x[1] == "Peter")
                    .Select(x => x[2])
                    .First();

Answer 4

try this

class Program
    {
        static void Main(string[] args)
        {
            List<string> resLines = new List<string>();
            var lines  = File.ReadLines("file.csv");
            foreach (var line in lines)
            {

                //here I suppose that your csv file it like this 
                    // 1,Peter,USA,12345
                    // 2,Anna,UK,45678
                var res = line.Split(new char[] {','});
              //or name to search 
                if (res[1] == "Peter")
                {                        
                    resLines.Add(res[2]);

                }
            }
            //to get the output  
            foreach (var line in resLines)
            {
                Console.WriteLine(line);
            }

        }
    }