Searching a csv file

Searching a csv file

• james79

  I should've posted my code that I have written so far (the second part is what I am trying to sort out - readPath2)...
  
  using System;
  using System.IO;
  
  public class Reader
  {
  public static void Main()
  {
  string readPath = "Master-res2007.csv";
  string writePath = "Master-res2007.txt";
  string data;
  
  if(File.Exists(readPath))
  {
  StreamReader reader = new StreamReader(readPath);
  
  // Read to end of file
  string file = reader.ReadToEnd();
  
  StreamWriter writer = new StreamWriter(writePath);
  
  // Write to text file
  writer.WriteLine(file);
  
  reader.Close();
  writer.Close(); // Free resources
  
  }else{
  Console.WriteLine("The file: " + (readPath) + " could not be found");
  }
  
  string readPath2 = "D-Ground.csv";
  
  if(File.Exists(readPath2))
  {
  StreamReader reader2 = new StreamReader(readPath2);
  
  //Read single line of text
  data = reader2.ReadLine();
  
  int peek = reader2.Peek();
  
  
  //While loop to check for Res-Code
  
  reader2.Close();
  //writer2.Close(); // Free resources
  
  }
  }
  }
  
  

• Nik_1982

  here's a few pre-done bits.

  http://www.heikniemi.net/hc/archives/files/CSVReader.cs

  http://www.codeproject.com/cs/database/CsvReader.asp

  Cheers,

  Greg

  
  
• Searching a csv file