C# split textfile into a 2 dimensional string array

Question

I have a textfile that looks like this :

John,Gauthier,blue,May
Henry,Ford,Red,June
James,Bond,Orange,December

I want to split it into a two dimensional string array so I could separate each lines then each words. Ex:

mystring[0][0] = "John"
mystring[1][3] = "June"
mystring[2][2] = "Orange"

Here's what I did right now:

string[] words = new string [100];
System.IO.StreamReader myfile = new System.IO.StreamReader("c:\\myfile.csv");

while (fichier.Peek() != -1)
{
  i++;
  words = myfile.ReadLine().Split(',');

}

I'm stuck. I'm able to split it into a one dimensional string array but not into a two dimensional string array. I guess I need to split it two times ; First time with '\n' and the second time with ',' and then put those two together.

Sten Petrov · Accepted Answer · 2013-01-18 21:20:08Z

8

This is actually a one-liner:

File.ReadLines("myfilename.txt").Select(s=>s.Split(',')).ToArray()

Since this is a beginner question, here's what's going on:

File.ReadLines(filename) returns a collection of all lines in your text file

.Select is an extension method that takes a function

s=>s.Split(',') is the function, it splits the string s by all commas and returns an array of strings.

.ToArray() takes the collection of string arrays created by .Select and makes an array out of that, so you get array of arrays.

answered Jan 18, 2013 at 21:20

Sten Petrov

11.1k1 gold badge45 silver badges63 bronze badges

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

2 Comments

Venson Over a year ago

Jea but i think he has already the same, he whats to Split the first like the Names and the Second in Different arrays not one Big array

Mr. Young Over a year ago

Confirmed this answer with linqPad

scartag · Accepted Answer · 2013-01-18 21:22:39Z

0

Try this

   var str = File.ReadAllText("myfile.csv");


 var arr = str.Split(new string[] {Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries);

   var multi = arr.Select(x => x.Split(',')).ToArray();

answered Jan 18, 2013 at 21:22

scartag

17.7k3 gold badges52 silver badges53 bronze badges

Comments

Venson · Accepted Answer · 2013-01-18 21:22:40Z

Try:

var First = new string [100];
var Sec = new string [100];
System.IO.StreamReader myfile = new System.IO.StreamReader("c:\\myfile.csv");

while (fichier.Peek() != -1)
{
  i++;
  var buff = myfile.ReadLine().Split(',');
  First[i] = buff[0];
  Sec[i] = buff[1];
}

Other idea, use a XML serilizer to serilize your hole Object. Two extensions for this:

    public static void SaveAsXML(this Object A, string FileName)
    {
        var serializer = new XmlSerializer(A.GetType());
        using (var textWriter = new StreamWriter(FileName))
        {
            serializer.Serialize(textWriter, A);
            textWriter.Close();
        }
    }

    public static void LoadFromXML(this Object A, string FileName)
    {
        if (File.Exists(FileName))
        {
            using (TextReader textReader = new StreamReader(FileName))
            {
                XmlSerializer deserializer = new XmlSerializer(A.GetType());
                A = (deserializer.Deserialize(textReader));
            }
        }
    }

Add than in any Static class and call:

YourSaveClassWhitchContainsYourArray.SaveAsXML("Datastore.xml");

or

YourSaveClassWhitchContainsYourArray.LoadFromXML("Datastore.xml");

Collectives™ on Stack Overflow

C# split textfile into a 2 dimensional string array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related