Hi,

I am pretty new to c# presently. I have a text file called tc.txt (comman separated) with the following content below:


T001,Dirks,c:\dirks\001.tif
T001,Dirks,c:\dirks\002.tif
T002,Matt,c:\matt\003.tif
T002,Matt,c:\matt\004.tif
T003,Ted,c:\Ted\005.tif
T003,Ted.c:\Ted\006.tif


When the file is read and written to another text file called output.txt (comma seperated). every line within the same folder should be written as follow;



T001,Dirks,c:\dirks\001.tif,c:\dirks\002.tif
T002,Matt,c:\matt\003.tif,c:\matt\004.tif
T003,Ted,c:\Ted\005.tif,c:\Ted\006.tif



Any help will be appreciated.

hi,

I am sending you a code snippet.....i am also new in c#,may be my code is little bit lengthy,but this code can do your job, if your text file contains many more data but in the same format as you have mentioned then also it will work fine.

The code is given below...



 static void Main(string[] args)
        {



            //FileStream fs = new FileStream("c:\\tc.txt", FileMode.Open, FileAccess.Read);
            StreamReader sr = File.OpenText("c:\\tc.txt");
            //fs.ReadByte();
            FileStream fs = new FileStream("c:\\output.txt",FileMode.Create,FileAc cess.Write);//this is the output file
            StreamWriter sw = new StreamWriter(fs);
            string str=null;
            int counter = 0;
            do
            {
                counter++;
                str = sr.ReadLine();
                if (str != null)//this loop prevents the last iteration
                {
                    int count = 0;
                    int position = 0;
                    if (counter % 2 == 0)
                    {
                        for (int i = 0; i < str.Length; i++)//this loop is for getting the position of the 2nd comma ","
                        {
                            if (str[i] == ',')
                            {
                                count++;
                                if (count == 2)
                                {
                                    position = i;//the position is captured here
                                    break;
                                }
                            }
                        }
                        str = str.Substring(position + 1);
                        sw.Write(str);
                    }
                    else
                        sw.Write(str + ",");
                    if (counter % 2 == 0) sw.WriteLine();

                }
                } while (str != null);
            sw.Close();
        }
    }


I hope it will help you.............If you face any problem you can further acknowlwdge me and if the code works plz inform me