I am trying to read the data in a text file which is separated by commas. My problem, is that one of my data pieces has a comma within it. An example of what the text file looks like is: a, b, "c, d", e, f. I want to be able to take the comma between c and d and change it to a semicolon so that I can still use the string.Split() method.

        using (StreamReader reader = new StreamReader("file.txt")) {
            string line;
            while ((line = reader.ReadLine ()) != null) {
                bool firstQuote = false;
                for (int i = 0; i < line.Length; i++) {
                    if (line [i] == '"' ) {
                        firstQuote = true;
                    }  
                    else if (firstQuote == true) {
                        if (line [i] == '"') {
                            break;
                        } 
                     if ((line [i] == ',')) {
                            line = line.Substring (0, i) + ";" + line.Substring (i + 1, (line.Length - 1) - i);
                        }
                    }

                }
                Console.WriteLine (line);
            }
        }

I am having a problem. Instead of producing a, b, "c; d", e, f, it is producing a, b, "c; d"; e; f. It is replacing all of the following commas with semicolons instead of just the comma in the quotes. Can anybody help me fix my existing code?