Reading CSV file and storing values into an array

Question

I am trying to read a *.csv-file.

The *.csv-file consist of two columns separated by semicolon (";").

I am able to read the *.csv-file using StreamReader and able to separate each line by using the Split() function. I want to store each column into a separate array and then display it.

Is it possible to do that?

Answer 1

You can do it like this:

using System.IO;  static void Main(string[] args) {     using(var reader = new StreamReader(@"C:\test.csv"))     {         List<string> listA = new List<string>();         List<string> listB = new List<string>();         while (!reader.EndOfStream)         {             var line = reader.ReadLine();             var values = line.Split(';');              listA.Add(values[0]);             listB.Add(values[1]);         }     } }