can any say how to remove the duplicates in a text file

Question

can any say how to remove the duplicates in a text file from the database

Ramesh Palanivel · Answer

Hi Bobi, Do you want to insert text file into DB or do you want to insert text file data's into DB?

Bobi B · Answer

Hi guys, i am developing a project on Removing duplicated chracters from a text file, i created a code to remvce the repeated words from a .txt file and its saving in a folder , but dont know how to insert in to database,, pls any one help protected void Button5_Click(object sender, EventArgs e) { FileUpload fu = FileUpload1; if (fu.HasFile) { StreamReader reader = new StreamReader(fu.FileContent); do { string textLine = reader.ReadLine(); char[] array = textLine.ToCharArray(); for (int i = 0; i { // Get character from array. char letter = array[i]; if (newtext == "") { newtext = array[i].ToString(); } else { char[] array1 = newtext.ToCharArray(); int flag = 0; for (int j = 0; j { if (array[i].ToString() == array1[j].ToString()) { flag = 1; } } if (flag == 0) { newtext = newtext + letter; } } } TextBox5.Text = FileUpload1.FileContent.Length.ToString(); string appPath = Request.PhysicalApplicationPath; string filePath = appPath + "Duplicated//" + FileUpload1.FileName + ""; StreamWriter w; w = File.CreateText(filePath); w.WriteLine(newtext); w.Flush(); w.Close(); } while (reader.Peek() != -1); reader.Close(); } }

Ramesh Palanivel · Answer

Hi Bobi, Try this code, to read text in text file using file streamreader, var fileStream = new FileStream(@ "c:\file.txt" , FileMode.Open, FileAccess.Read); using (var streamReader = new StreamReader(fileStream, Encoding.UTF8)) { textBox1.Text= streamReader.ReadToEnd(); }

Bobi B · Answer

sorry Nitin Sontakke,, i am a beginer , in my uploaded file ,, my project is there,, in that i have to upload one text file,, after uploading i should remove the duplicates in that particular text file,,, pls help

Nitin Sontakke · Answer

I still don't understand my dear friend. Please type more. Please tell EVERYTHING. Assuming you are having a windows forms application, you can do something like: String strFilename = "C:	emp\somefile.txt"; // put your filename here. txtFileContents.Text = File.ReadAllText(strFilename);

Nitin Sontakke · Answer

Dear Friend, it is ONLY you who is aware of your situation. We are the people very limited imagination (or atleast I am)! Could you please elaborate a bit? What database, what file? which duplicates? Any sample data? anything to look at and understand what you want to achieve?