Reading data from a CSV to an array of arrays (C#)

Question

I have the CSV file opened, but I can't figure out how to put the resultant array from splitting the line into another array. I have the following code currently, hopefully it gives more of an idea of what I'm meaning:

    private void ReadFileToArray(StreamReader file)
    {
        int i = 0;
        string[][] FP_GamesArray;
        while (!file.EndOfStream)
        {
            string line = file.ReadLine();
            if (!String.IsNullOrWhiteSpace(line))
            {
                string[] values = line.Split(',');
                MessageBox.Show(values.ToString());
                FP_GamesArray[i] = values;
            }
            i++;
        }
    }

Any ideas? I get two errors: One saying Cannot implicitly convert type 'string[]' to 'string' and second saying Use of unassigned local variable 'FP_GamesArray'.

An array isn't dynamic, you can't just declare it like you have and start assigning values to it You have to give it a size as well. Where are you getting the first error? — tnw
– tnw, Commented Jul 1, 2014 at 18:23
Both are tied to the FP_GamesArray[i] = values line, the first error is underlining the values code, and the second the FP_GamesArray[i] code. — dantdj
– dantdj, Commented Jul 1, 2014 at 18:27

Selman Genç · Accepted Answer · 2014-07-01 18:34:23Z

7

You need to initialize your array, to do that you need to know how many lines in there.

Instead of reading line by line you can do:

string[][] FP_GamesArray = File.ReadLines("path")
                          .Select(line => line.Split(','))
                          .ToArray();

Or altenatively, you can start with a List<string[]>, use it's add method, then convert it to an array after the reading is finished, like below:

List<string[]> lines = new List<string[]>();
while (!file.EndOfStream)
{
     string line = file.ReadLine();
     if (!String.IsNullOrWhiteSpace(line))
     {
         lines.Add(line.Split(',');   
     }
}

string[][] FP_GamesArray = lines.ToArray();

edited Jul 1, 2014 at 18:34

answered Jul 1, 2014 at 18:25

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Black Frog Over a year ago

I like the List<string[]> option because a lot of people don't understand Linq.

dantdj Over a year ago

Works a treat! Thanks a lot. I'll try the List<string[]> method for completeness in a bit...

Vasily Hall · Accepted Answer · 2017-08-30 19:37:16Z

0

As a supplemental answer for the means of producing a list, here is what I was able to get to work:

  List<string> rows = MyCSVString.Replace("\n", "").Split('\r').ToList();
  List<List<string>> listedMatrix = new List<List<string>>();
  foreach(var x in rows)
  {
    if(x != "")
    {
      var rowList = x.Split(',').ToList();
      listedMatrix.Add(rowList);
    }
  }

yea, commas will mess it up, as this isn't really true parsing.

edited Aug 30, 2017 at 19:37

answered Aug 29, 2017 at 18:32

Vasily Hall

96110 silver badges25 bronze badges

Collectives™ on Stack Overflow

Reading data from a CSV to an array of arrays (C#)

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related