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 · 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 mehra · 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 mehra · 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 mehra · 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 mehra · 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(); } } } }