text file data we need in column way using c#

Question

sir ,,,I have multiple text files each having two columns data with headings .I have merged all those files into one .now all the text files got merged and results into a single text file "output.txt" In this text file each file is added at the end of first file with its heading and data .
Like this :
Wavelength S100141.asd 325 0.015082292401682  326 0.011690540571175  327 1.06575414031349E-02  328 1.30298010496599E-02
Wavelength S100144.asd 325 1.35059549289737E-02  326 0.010981114226419  327 1.22348778870862E-02  328 1.63555124470031E-02
Wavelength S100147.asd 325 1.35059549289737E-02  326 0.010981114226419  327 1.22348778870862E-02  328 1.63555124470031E-02
I want the result to appear like this :
Wavelength      S100141.asd                    S100144                          S100147 325       0.015082292401682           1.35059549289737E-02   1.35059549289737E-02  326      0.011690540571175             0.010981114226419              0.010981114226419  327      1.22348778870862E-02       1.06575414031349E-02         1.22348778870862E-02  328     1.63555124470031E-02      1.30298010496599E-02          1.63555124470031E-02
anybody can help

Dhirendra Misra · Accepted Answer

Try this:
class ReadMergeTextFiles     {         string path = @"C:\Dhirendra\Learning\Corner\SampleFiles";
public void MergeFiles(string targetFile)         {             StringCollection mergedValuesCollection = new StringCollection();             //Get files from openFileDialog             string[] arrFiles = { "S100141.asd.txt", "S100144.asd.txt" }; //Lets take file names             foreach (string fname in arrFiles)             {                 mergedValuesCollection = ReadFile(fname, mergedValuesCollection);             }
//Write to file             using (StreamWriter file = new StreamWriter(path + targetFile))             {                 foreach (string line in mergedValuesCollection)                 {                         file.WriteLine(line);                 }             }         }
public StringCollection ReadFile(string fileName, StringCollection mergedValues)         {             int i = 0;             string filePath = path + fileName;
try             {                 using (StreamReader sr = new StreamReader(filePath))                 {                     String line = string.Empty;                     while ((line = sr.ReadLine()) != null) //Assuming there is white space seperator for each line.                     {                         line = line.Substring(line.IndexOf(' '), line.Length - line.IndexOf(' ')).Trim();                         if (i != 0)                         {                             double val = Double.Parse(line);                             line = string.Format("{0, 8:F6}", val);                         }                         else                             line = string.Format("{0, 11}", line);                         if (mergedValues.Count > i && mergedValues[i] != null)                             mergedValues[i] += "	" + line;                         else                             mergedValues.Add(line);                         i++;                     }                 }             }             catch (Exception e)             {                 Console.WriteLine("The file could not be read:");                 Console.WriteLine(e.Message);             }
return mergedValues;         }     }
Call from Main:
ReadMergeTextFiles objReadMergeTextFiles = new ReadMergeTextFiles();             objReadMergeTextFiles.MergeFiles("mergedOutput.txt");

Meenakshi Kumari Syal · Answer

sorry sir I dont know where is the error but no output is generated .. i'm writing my whole code pls  see and chk my code ......
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Collections.Specialized; using System.IO;
namespace TextFiles {     public partial class ReadMergeTextFiles : Form     {        String path= @"C:";        OpenFileDialog dialog1 = new OpenFileDialog();
public ReadMergeTextFiles()         {             InitializeComponent();         }
public void MergeFiles(string targetFile)         {             StringCollection mergedValuesCollection = new StringCollection();             //Get files from openFileDialog             string[] arrFiles = { dialog1 .FileName  }; //Lets take file names             foreach (string fname in arrFiles)             {                 mergedValuesCollection = ReadFile(fname, mergedValuesCollection);             }
//Write to file             using (StreamWriter file = new StreamWriter(path + targetFile))             {                 foreach (string line in mergedValuesCollection)                 {                     file.WriteLine(line);                 }             }         }
public StringCollection ReadFile(string fileName, StringCollection mergedValues)         {             int i = 0;             string filePath = path + fileName;
try             {                 using (StreamReader sr = new StreamReader(filePath))                 {                     String line = string.Empty;                     while ((line = sr.ReadLine()) != null) //Assuming there is white space seperator for each line.                     {                         line = line.Substring(line.IndexOf(' '), line.Length - line.IndexOf(' ')).Trim();                         if (i != 0)                         {                             double val = Double.Parse(line);                             line = string.Format("{0, 8:F6}", val);                         }                         else                             line = string.Format("{0, 11}", line);                         if (mergedValues.Count > i && mergedValues[i] != null)                             mergedValues[i] += "	" + line;                         else                             mergedValues.Add(line);                         i++;                     }                 }             }             catch (Exception e)             {                 Console.WriteLine("The file could not be read:");                 Console.WriteLine(e.Message);             }
return mergedValues;         }
private void button2_Click(object sender, EventArgs e)         {             ReadMergeTextFiles objReadMergeTextFiles = new ReadMergeTextFiles();             objReadMergeTextFiles.MergeFiles("mergedOutput.txt");
}
private void button1_Click(object sender, EventArgs e)         {             dialog1.Multiselect = true;             dialog1.Filter = "Text files (*.txt)|*.txt";             dialog1.RestoreDirectory = true;             dialog1.Title = "Add Files";             if (dialog1.ShowDialog() == DialogResult.OK)             {
string[] fileNameAndPath = dialog1.FileNames;                 string[] filename = dialog1.SafeFileNames;
for (int i = 0; i                 {                     listView1.Items.Add(filename[i] + "  " + fileNameAndPath[i]);
}                 label1.Text = Convert.ToString(listView1.Items.Count);             }         }
} }    I'm merging txt files as earlier i have told u .....

Dhirendra Misra · Answer

Hello Meenakshi,
Sorry for detailed response. I was out of internet access.
In form load you can write this code:
OpenFileDialog MyDialog = new OpenFileDialog();
MyDialog.Multiselect = true ; MyDialog.Filter = "WAVE files (*.wav)|*.wav|All files (*.*)|*.*" ; MyDialog.RestoreDirectory = true ; MyDialog.Title = "Add Files";
for( int i; i listView.Items.Add( MyDialog.FileNames[i], i);
Then in merge button click you call the following as suggested earlier.
ReadMergeTextFiles objReadMergeTextFiles = new ReadMergeTextFiles(); objReadMergeTextFiles.MergeFiles("mergedOutput.txt");

Meenakshi Kumari Syal · Answer

sir your solution is write but i dont know how to execute it .......and at last you have written call from main ....
I want to use opendialog box to select multiple text files  and list file path at listview.one label indicating number of files selected.and on button merge click those all files get merged in such a way
Wavelength     S100150.asd                         S100144.asd              S100147.asd 325        1.77381492817998E-02         1.35059549289737E-       1.38996519972825E-02  326         1.71685460312564E-02         0.010981114226419         1.27584817177226E-02  327           1.69462332730193E-02      1.22348778870862E-02      1.39619660716966E-02  328          1.71723179313877E-02         1.63555124470031E-02     1.68906279551465E-02
please help me to get ouput like this .

Meenakshi Kumari Syal · Answer

sir your solution is write but i dont know how to execute it .......and at last you have written call from main ....

Vulpes · Answer

meenakshi,
I don't understand that error if the format of the file is what you say it is and you're using the code exactly as posted. The code worked fine with the sample file you gave.
'name' can't be null in the while statement as there is an explicit check for nullness prior to adding it to the dictionary.
'name' can only be null after the while statement ends if there is no line in the file which starts with 'Wavelength'.
So can you post (or zip and attach) the actual file you're using so I can check it.

Meenakshi Kumari Syal · Answer

Sir problem is here in this code : error is
Value cannot be null. Parameter name: key
dict.Add(name, list);
now suggest me

Vulpes · Answer

Try this:
using System; using System.Collections.Generic; using System.IO; using System.Linq;
class Program {    static void Main()    {       var dict = new SortedDictionary >();          var wavelengths = new List ();       SortedList list = null;       string name  = null;       int wavelength = 0;       string[] items = null;       char[] empty = {' '};       string blank = new string(' ', 22);        StringSplitOptions ree = StringSplitOptions.RemoveEmptyEntries;
using (var sr = new StreamReader("output.txt"))       {          string line;
while ((line = sr.ReadLine()) != null)          {             line = line.Trim();             if (line.Length == 0) continue; // skip blank lines             if(line.StartsWith("Wavelength"))             {                if(name != null)                {                  dict.Add(name, list);                }                name = line.Replace("Wavelength", "").TrimStart();                      list = new SortedList ();             }             else             {                items = line.Split(empty, ree);                wavelength = int.Parse(items[0]);                wavelengths.Add(wavelength);                list.Add(wavelength, items[1]);             }          }       }
dict.Add(name, list);       wavelengths = wavelengths.Distinct().OrderBy(wl => wl).ToList();
using(var sw = new StreamWriter("output2.txt"))       {          sw.Write("Wavelength  ");
foreach(string key in dict.Keys)          {             sw.Write("{0, -22}", key);          }
sw.WriteLine();
foreach(int wl in wavelengths)          {             sw.Write("{0, -12}", wl);                foreach(string key in dict.Keys)             {                list = dict[key];                  if(list.ContainsKey(wl))                {                   sw.Write("{0, -22}", list[wl]);                }                else                {                   sw.Write(blank);                }            }
sw.WriteLine();          }       }    } }