strings from csv file into multidimensional array

Question

right now i try to convert data from an csv file into an multidimensional array. The data are some simple attributes for playable characters in an DOS consoleapplication (mostly text). The file is build like this

"name; gender; role; hp; selectiontoken"

There are 6 different characters (two for each role). Each character should be a row in the array and every attribute should be a column.

static void Main(string[] args)
{
    string[,] values= new string [5,6];

    var reader = new StreamReader(File.OpenRead(@"C:\path"));
    while (!reader.EndOfStream)
    {

        string line = reader.ReadLine();
        values = line.Split(';'); //Visual C# 2010 Express gives me an error at this position "an implicated conversion between string [] and string [,] is not possible"
    }

My question is, how can I split the colums in "line" to give them into "values"?

String.Split returns a string[] not a multi-dimensional array. — Tim Schmelter
– Tim Schmelter, Commented Feb 19, 2015 at 14:24
This is a good solution on how to parse CSV in C# stackoverflow.com/questions/2081418/… — ClemensOe
– ClemensOe, Commented Feb 19, 2015 at 14:33
I can't imagine why you'd want to load these into a two-dimensional array as though you were writing Fortran 40 years ago, when you could easily create a class that has real properties and other innovations that you see in modern programming languages. — Jim Mischel
– Jim Mischel, Commented Feb 19, 2015 at 16:02

mybirthname · Accepted Answer · 2015-02-19 14:29:54Z

2

Like Tim explain you, String.Split return string[]. You can store it in List<string[]> if you want.

static void Main(string[] args)
{
    List<string[]> values= new List<string[]>();

    var reader = new StreamReader(File.OpenRead(@"C:\path"));
    while (!reader.EndOfStream)
    {

        string line = reader.ReadLine();
        values.Add(line.Split(';'));
    }
}

answered Feb 19, 2015 at 14:29

mybirthname

18.2k3 gold badges35 silver badges59 bronze badges

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

2 Comments

ScaleoJ Over a year ago

The problem with this is, that i want to use the array later to display the characters and load the selected ones into variables without searching for the right row in several lists.

mybirthname Over a year ago

Better see how to read CVS to DataTable/DataSet after that you can use it for whatever you want. Also next time write your goal in the question.

Collectives™ on Stack Overflow

strings from csv file into multidimensional array

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related