How to delete two strings always from my text file and then start my below codes

Question

I would like to always delete two strings from my text file while reading it. DOC and PCB. so when ever these two strings is coming i would like to delete them and start my process. Please have a look to my output file https://imageshack.com/i/ipUcSIo2j i need the output file without these strings.

How can i do this. But i need my output Location column numbering should not vomit any numbers in between

My code snippet:

         string search_text = "PCB";
        string old;
        string n = "";
        StreamReader sr = File.OpenText(textBox1.Text);
        while ((old = sr.ReadLine()) != null)
        {
            if (!old.Contains(search_text))
            {
                n += old + Environment.NewLine;
            }
        }
        sr.Close();
        File.WriteAllText(textBox1.Text, n);

Answer 1

Firstly, see this question and it's accepted answer Efficient way to delete a line from a text file

So you need to do that, read through the file, writing the lines you want to a new file, and skipping the lines you don't want. There actually is NO way to delete lines from a text file, and this is how you fake the delete.

Then run your code on the new file.

Do you need help identifying the lines to remove, or are you OK with that?

Answer 2

I think it should be simple like this.

string[] search = new string[] {"DOC","PCB"};
var lines = System.IO.File.ReadAllLines(@"D:\MyFile.txt");
var result1 = lines.Where(item => !item.Contains(search[0]) && !item.Contains(search[1]));
StringBuilder sb = new StringBuilder();
foreach (string line in result1)
{
    sb.AppendLine(line);
}

Answer 3

i got the answer..For deleting two word plus entire line i used two different functions, where each function servers a different role. Please have a look to my answer. I know that this is bit lengthy and it can be done suing an array system. If any better answers are posted i am ready to accept it.

 public void do_name()
    {
        string search_text = "PCB";
        string old;
        string n = "";
        StreamReader sr = File.OpenText(textBox1.Text);
        while ((old = sr.ReadLine()) != null)
        {
            if (!old.Contains(search_text))// || !old.Contains(next_text)) 
            {
                n += old + Environment.NewLine;
            }
        }
        sr.Close();
        File.WriteAllText(textBox1.Text, n);
    }

    public void do_name1()
    {
        string next_text = "DOC";
        string old;
        string n = "";
        StreamReader sr = File.OpenText(textBox1.Text);
        while ((old = sr.ReadLine()) != null)
        {
            if (!old.Contains(next_text))// || !old.Contains(next_text)) 
            {
                n += old + Environment.NewLine;
            }
        }
        sr.Close();
        File.WriteAllText(textBox1.Text, n);
    }
    Dictionary<string, int> namesForCarousels = new Dictionary<string, int>();
    private void button1_Click(object sender, EventArgs e)
    {
        string path = "";
        string filename_noext = "";
        OpenFileDialog ofd = new OpenFileDialog();
        ofd.InitialDirectory = @"C:\files";
        ofd.Filter = "TXT files (*.txt)|*.txt";
        ofd.FilterIndex = 2;
        ofd.RestoreDirectory = true;

        if (ofd.ShowDialog() == DialogResult.OK)
        {
            filename_noext = System.IO.Path.GetFileName(ofd.FileName);
            path = Path.GetFullPath(ofd.FileName);
            textBox1.Text = path;
            do_name();
            do_name1();
            //MessageBox.Show(filename_noext, "Filename"); - - -> switching.grf
            //MessageBox.Show(path, "path");
            //Give the column width according to column index.
            int[] cols = new int[] { 15, 15, 25, 15, 15 };
            string[] strLines = System.IO.File.ReadAllLines(textBox1.Text);

            StringBuilder sb = new StringBuilder();
            string line = string.Empty;
            string LastComment = string.Empty;
            string CarouselName = "Carousel";
            int iCarousel = 0;

            for (int i = 0; i < strLines.Length; i++)
            {

                line = RemoveWhiteSpace(strLines[i]).Trim();
                string[] cells = line.Replace("\"", "").Split('\t');

                for (int c = 0; c < cells.Length; c++)
                    sb.Append(cells[c].Replace(" ", "_").PadRight(cols[c]));

                if (cells.Length > 1)
                {
                    var name = cells[1];
                    int carouselNumber;
                    if (namesForCarousels.TryGetValue(name, out carouselNumber) == false)
                    {
                        carouselNumber = iCarousel++;
                        namesForCarousels[name] = carouselNumber;
                    }
                    if (i == 0)
                        sb.Append("Location".PadRight(15));
                    else
                        sb.Append(String.Format("{0}:{1}", CarouselName, carouselNumber).PadRight(15));
                }
                sb.Append("\r\n");
            }

            System.IO.File.WriteAllText(textBox1.Text, sb.ToString());
           // do_name1();
            Application.Exit();
        }
    }

Answer 4

Just put that code in the ctor/constructor under InitializeComponent();