C# csv to jaggedarray (How to return Columns)

Asked Sep 17 '20 at 02:25

Active Sep 17 '20 at 02:25

Viewed 97 times

I have a csv file that I need to capture data from. I have code that I found on stack overflow that returns that csv data in the form of a jagged array, I have never worked with jagged arrays before and I'm having a tough time figuring out how to loop through the data.

My idea is to have a function that returns column data from the array

        public static string[][] retJaggedArray(int row, int column, string file)
        {
            string[][] m_Data = File
                .ReadLines(file)
                .Where(line => !string.IsNullOrWhiteSpace(line))
                .Select(line => line.Split(','))
                .ToArray();

            return m_Data;
        }

string[] data = retJaggedArray(23, 1, file); >> returns the column data

Please also let me know the conventions of dealing with a jagged array

asked Sep 17 '20 at 02:25

JonJames

By columns data, do you mean if there's a column X, return an array containing each row values of column X? – Martheen Sep 17 '20 at 02:33
3

For parsing CSV files, use one of the existing [CSV parsing libraries](https://stackoverflow.com/q/2081418/8967612) and don't reinvent the wheel. It's not as easy as it might seem. – 41686d6564 stands w. Palestine Sep 17 '20 at 02:34
Ill look into the link you gave, thanks man – JonJames Sep 17 '20 at 02:38

C# csv to jaggedarray (How to return Columns)

0 Answers0