find and delete duplicate two lager files?

eddie
2014-03-07
2014-03-15
  • eddie

    eddie - 2014-03-07

    hi i have two large phone numbers files saved in different names
    file1 and file2 they only have numbers like 1234567890
    2345678901
    ....

    i want find if file1 has duplicated numbers in file2 since file1 is large file too AND i don;t want change the order of file2 ?

     
  • cchris

    cchris - 2014-03-08

    There is a SQL plugin that may help you, since you want to extract or remove all items in file2 which are on file1 or vice versa.
    Give it a try, this is the closest from your request that I can think of.

    CChris

     
  • eddie

    eddie - 2014-03-09

    how to use SQL plugin ? thanks

     
  • cchris

    cchris - 2014-03-15

    The SQL plugin assumes a CSV file where the first row is made of the column names. Whn you hit SQL -> SQL, you can enter a SQL query where the provider table is called "data" and is the current file. You can enter any SQL with this single provider and all the limitations of the SQLite dialect. Hit "execute", and a new document will be created with the results, assuming there were no errors.

    CChris

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks