VB script :searching and deletion of unmatch rows from 2 different files. RRS feed

  • Question

  • I Have a file in notepad++ which contains around 2lakh 50 thousand rows.each row has a unique number.

    In excel sheet i have the  unique number listed. count is around 500.

    i want fetch the unique number from sheet and then search it in notepad++ rows .if it matches then fine else the row should be deleted from the file..

    this will be for all 500 rows .

    is it possible with VBscipt?or can be done with other logic?

    can anyone please advice?
    Wednesday, July 2, 2014 8:09 PM