Hello,
I have to cleand up many files. Is it possible by using a macro to doing something like that?
I only want to delete lines in File 2, who have an entry in File1.
For Example:
File1: 400 entries
2104677 --- this customer should be deleted in File2
2184943
1391879
2351252
4248990
1408022
1409449
5120910
5154349
File2: 1600 entries
2100149," Text"Text"
2103401," Text"Text"
2104677," Text"Text" --- same customernumber from File1 this line should be deleted
2107837," Text"Text"
2107944," Text"Text"
2108751," Text"Text"
2110054," Text"Text"
2111580," Text"Text"
2111870," Text"Text"
2113397," Text"Text"
2114312," Text"Text"
Thanks for all answers.
Best wishes,
Andreas Harde
I have to cleand up many files. Is it possible by using a macro to doing something like that?
I only want to delete lines in File 2, who have an entry in File1.
For Example:
File1: 400 entries
2104677 --- this customer should be deleted in File2
2184943
1391879
2351252
4248990
1408022
1409449
5120910
5154349
File2: 1600 entries
2100149," Text"Text"
2103401," Text"Text"
2104677," Text"Text" --- same customernumber from File1 this line should be deleted
2107837," Text"Text"
2107944," Text"Text"
2108751," Text"Text"
2110054," Text"Text"
2111580," Text"Text"
2111870," Text"Text"
2113397," Text"Text"
2114312," Text"Text"
Thanks for all answers.
Best wishes,
Andreas Harde