Hi all, I am trying to delete all the lines that do NOT contain 1010001 and 1010003. Can anybody help how to make this job much easier?
Thanks, below is a bit of a data.
1010001,1960,1,67.1,-11.01010001,1960,2,101.0,-5.41010001,1960,3,56.3,-6.21010001,1960,4,77.5,2.11010001,1960,5,74.0,13.41010001,1960,6,91.1,15.91010001,1960,7,102.2,17.01010001,1960,8,67.8,17.11010001,1960,9,74.8,13.01010001,1960,10,96.7,5.31010001,1960,11,70.5,0.91010001,1960,12,89.3,-8.91010002,1960,1,67.1,-10.71010002,1960,2,104.5,-4.91010002,1960,3,56.8,-6.11010002,1960,4,77.3,2.31010002,1960,5,71.5,13.61010002,1960,6,91.6,16.01010002,1960,7,104.2,17.21010002,1960,8,60.8,17.21010002,1960,9,77.4,13.21010002,1960,10,101.2,5.31010002,1960,11,70.0,0.91010002,1960,12,87.1,-8.71010003,1960,1,70.9,-11.41010003,1960,2,98.1,-5.41010003,1960,3,57.4,-6.01010003,1960,4,78.2,1.81010003,1960,5,78.7,13.51010003,1960,6,87.5,15.91010003,1960,7,103.0,17.21010003,1960,8,76.7,17.31010003,1960,9,68.6,12.91010003,1960,10,90.9,5.21010003,1960,11,70.0,0.91010003,1960,12,100.7,-9.01010004,1960,1,77.5,-11.11010004,1960,2,108.6,-5.11010004,1960,3,58.4,-5.71010004,1960,4,80.4,2.11010004,1960,5,76.8,13.51010004,1960,6,108.8,16.01010004,1960,7,101.4,17.41010004,1960,8,48.8,17.51010004,1960,9,62.5,13.21010004,1960,10,100.0,5.41010004,1960,11,70.0,1.21010004,1960,12,106.9,-8.81010005,1960,1,95.2,-10.51010005,1960,2,104.2,-4.71010005,1960,3,58.9,-5.01010005,1960,4,68.7,2.91010005,1960,5,74.3,13.81010005,1960,6,106.6,16.41010005,1960,7,102.8,17.91010005,1960,8,30.9,17.91010005,1960,9,47.9,13.21010005,1960,10,98.7,5.6
Best Answer