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

Bobi B

9y843Learn iOS Programming

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
Hi Bobi,

Do you want to insert text file into DB or do you want to insert text file data's into DB?
0
Bobi B9y ago
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 < array.Length; 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 < newtext.Length; 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();
}
}
0
Ramesh Palanivel9y ago
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();
}
0
Bobi B9y ago
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
0
Nitin Sontakke9y ago
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:\temp\somefile.txt"; // put your filename here.
txtFileContents.Text = File.ReadAllText(strFilename);
0
Nitin Sontakke9y ago
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?
0

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

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