Remove contents of one txt file from another?

Question

Text Processing Automation

Hello, tell me if it is possible to somehow implement the following task.
There are 2 txt files, they contain email addresses, one has unnecessary addresses, the other has the entire database.
How to delete from the database (second file) the contents of the first file (unnecessary addresses), manually delete several thousand addresses for a very long time. There is a program AF9 Replace some bytes 1.2. But again, first you need to copy one address into the form and add it, but everything is not possible at once, it does not make sense, because it will take even longer.
What can be done in this situation?

Answer 1

Well, for example, google first "load csv to sqlite" then "sql not in query" then "export sqlite to csv"
I suspect that there are more than a dozen options

Answer 2

Script to delete
http://stackoverflow.com/a/5002/deleting-lines-from-one-f...

Answer 3

Vladimir
stul5tul I installed sqlite3 but this script does not remove the contents of the second file from the first one.. what could be the problem? email in files one per line are written

create table file1(line text);
create index if1 on file1(line ASC);
create table file2(line text);
create index if2 on file2(line ASC);
.import 'c:\sql\r\mail.txt' file1
.import 'c:\sql\r\r.txt' file2
.output res.txt
select * from file2 where line not in (select line from file1);