hi i have two large phone numbers files saved in different names
file1 and file2 they only have numbers like 1234567890
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 ?
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.
how to use SQL plugin ? thanks
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.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.