Hi, I need software to remove lines in a text file that contain strings from another text file. The files will contain mainly text data and URLs. The software should then output the result.
It should work as follows:
-Load the first text file which will be a TXT or CSV (60-300MB large)
-Load the second file TXT 10-20MB large
-Search for lines in the first file that contain strings from each line in the second file
-If a line in the first file contains a string from a line in the first file, delete it
-Save the first file (as an optional setting)
-Save a text file of the first column of a CSV file, without commas or quotes (as an optional setting)
*the software should have a preset settings file for all settings and files involved, and be able to run with a commandline argument to use preset settings and output the files automatically instead of waiting for a user input
**the software should have a GUI
**I will require all code at the end of the project and I would prefer this made in VB.Net
Thanks for bidding and please see the example output below.
Example Output:
First File:
Line 1: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","1"
Line 2: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","2"
Line 3: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","3"
Line 4: "[login to view URL]",'[login to view URL]","A - CATEGORY1","A - CATEGORY2","4"
Line 5: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","5"
Line 6: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","6"
Line 7: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","7"
Line 8: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","8"
Line 9: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2,9
Line 10: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","10"
Second File:
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
Result:
CSV File:
Line 1: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","1"
Line 4: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","3"
Line 6: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","4"
Line 7: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","5"
Line 8: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","6"
Line 9: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","7"
Line 10: "[login to view URL]","[login to view URL]","A - CATEGORY1","A - CATEGORY2","8"
Text File:
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]