Reading CSV file and storing values into an array

.net, arrays, c#, csv

Solution

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]);
        }
    }
}

Problem

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?

Original source