Reading and modifying contects ofcsv file

Question

I want to read a csv file which is having many columns but I want to take only the first column and would like to save the first value in a string array and also want to save the last value of the same column in another string array.

please help me in this I am new to C#

Vulpes · Answer

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 { 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(); } }