• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

using Split() Method to separate out data into Array

I have a Console application that gets a filename passed as an argument. It then stores that filenames data to an array, gets opened and then read line by line and stored to another array.
I'm currently using the FileStream ReadLine() method to pull out the workstations one by one and store to this Array. The escape sequence is \r\n. However, if I receive a text file whereby the data has delimiters like a semi-colon (;) or commas (,) or whatever, I would like to change the code to allow me to handle these. What other class can I use to Open this file and retrieve and store data to array while handling / splitting out the escape sequences properly?
Thanks Experts,
Wally
static void Main(string[] Args)
        {
            // Do Database Query Here.....
            // This will hold the entire workstation 
            // list that is pulled from the Nodes table
            List<Program> nodeList = new List<Program>();
            string idx = "";
            if (Args.Length >= 1)
            {
                for (int i = 0; i < Args.Length; i++)
                {
                    idx = Args[i];
                    //Console.WriteLine(idx);
                }
            }
 
            string filename = "";
                filename = Args[0];
                filename = filename.ToUpper();
                //Console.WriteLine(clArgs[0]);
                if (File.Exists(filename))
                {
                    FileStream fs = new FileStream(filename, FileMode.Open, FileAccess.Read);
                    using (StreamReader sr = new StreamReader(fs))
                    {
                        string line;
                        while ((line = sr.ReadLine()) != null)
                        {
                            Program node = new Program();
                            node.NodeToPing = line;
                            nodeList.Add(node);
                        }
                    }
                }

Open in new window

0
wally_davis
Asked:
wally_davis
1 Solution
 
mrcoolcoderCommented:
What I do when I want to allow multiple escape characters is I use replace.

So "," will become ";"
And ":" will become ";"
And So on...

Then you just run your split function.
0
 
wally_davisAuthor Commented:
What I'm looking for is some help on how to modify the code above since there is no .Replace() Method within the StreamReader.
0
 
philipjonathanCommented:
Try changing lines 24-33 to:

using (StreamReader sr = new StreamReader(fs))
{
  string data = sr.ReadToEnd();
  string[] nodeDatas = data.Split(new char[] {',', ';', '\r', '\n'});
  foreach (string line in nodeDatas)
  {
    if (!nodeData.Trim().Equals(string.Empty))
    {
      Program node = new Program();
      node.NodeToPing = line;
      nodeList.Add(node);
    }
  }
}

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now