|
Script that extract some lines from a file lookin into another
I want a ksh script that parse two files (text files, actually my original files are .xls) - input data:
- one file file1 containig lines separated by spaces (or other delimiter)
- 2nd one file2 contain only one numerical value in a line (for simplicity but it might of the same form as the 1st)
- I know the 2nd value in file1 is also numerical and some of them can be found in file2
Output data:
The result should be a file that contains from the file1 only those lines whose 2nd field cannot be found in any line of file1.
I know this is easy, but I am too tired after a full hard working day so an expert can fix it in a minute.
I think it can be done in one line (complex?) command either....
|