Read text data from file using LINQ

Question

I have following text file:

37 44 60
67 15 94
45 02 44

How to read all numbers from this file and save them into two-dimensional array, using LINQ? All I manged to do was creating a simple array with all first values in each row. Is using LINQ in this case a good idea or should I simply load the file normal way and parse it?

Answer 1

Do you mean something like this?

StreamReader sr = new StreamReader("./files/someFile.txt");

      var t1 =
        from line in sr.Lines()
        let items = line.Split(' ')
        where ! line.StartsWith("#")
        select String.Format("{0}{1}{2}",
            items[1],
            items[2],
            items[3]);

Take a look to this web: LINK

Answer 2

File.ReadAllLines(myFile)
    .Select(l => l.Split(' ')
        .Select(i => int.Parse(i)).ToArray())
    .ToArray();

or

List<int[]> forThoseWhoHave1GigFiles = new List<int[]>();
using(StreamReader reader = File.OpenText(myFile))
{
    while(!reader.EndOfStream)
    {
        string line = reader.ReadLine();
        forThoseWhoHave1GigFiles.Add(line.Split(' ')
            .Select(i => int.Parse(i)).ToArray());
    }
}
var myArray = forThoseWhoHave1GigFiles.ToArray();

Answer 3

Just to complete Jonathan's answer, here's how you could implement the Lines extension method :

public static class TextReaderExtensions
{
    public static IEnumerable<string> Lines(this TextReader reader)
    {
        string line;
        while((line = reader.ReadLine()) != null) yield return line;
    }
}