Reading and modifying contects ofcsv file

If the number of lines in the file is not too large, then you could do it like this:

using System;

using System.IO;

class Program

{

static void Main()

{

// load all line from file

string[] lines = File.ReadAllLines("pankaj.csv");

// find out how many columns there are

// it's assumed all lines are data lines i.e. no headers or blank lines

// it's also assumed that columns are separated by commas

int numCols = lines[0].Split(',').Length;

// put first and last column values in their own arrays

string[] firstCol = new string[lines.Length];

string[] lastCol = new string[lines.Length];

for(int i = 0; i < lines.Length; i++)

{

string[] items = lines[i].Split(',');

firstCol[i] = items[0];

lastCol[i] = items[numCols - 1];

}

// check it worked

foreach(string s in firstCol) Console.WriteLine(s);

Console.WriteLine();

foreach(string s in lastCol) Console.WriteLine(s);

Console.ReadKey();

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.