I have a text file with 65,000+ lines. I need someone to help me modify this file by removing lines that contain certain text strings. Then I need a new file containing only the lines that were removed.
This could be done by importing the data into SQL or using a PERL script or Excel or whatever. I don't care how it's accomplished since I don't really need any software--I only need the resulting output files (although if you want to provide an application that will do the job, that's fine as well).
Here is an example:
**Text to remove:
**New File 1 (remove lines containing MSP & BOS):**
**New File 2 (include only lines containing MSP & BOS):**
The combination of the two new files should contain the same number of lines as the original file.
The deliverable is 2 text files. The first file should contain everything from the original source file, EXCEPT for the lines with the strings being removed, and the second file should contain ONLY the lines with the strings that have been removed from the original source file.
The original source file as well as the file with the strings to be removed are attached. Good luck bidding.