In the example below, I need to search for and delete any strings similiar to the "1 EA 4.25" on line three, with the only consant being the "EA". The "1" and the "4.25" may be any value. (Application will be tab delimited text files.)
The trouble I've had is that AFR also finds the first instance of "EA" on lines one, two and four.... text I want to retain, and deletes it. The instances I want to retain will never have values on either side of them.
How should the search language read? Thanks.
Code: Select all
2 1 EA 44985017 TROUGH WDMT-FINES, CROSS (4800 MS)
3 1 EA 44986017 AUGER WDMT-FINES, CROSS (4800 MS)
4 4 IN 00643019 KEYSTOCK-1018 CD STL, 0.19 X 0.25 1 EA 4.25
5 4 EA 00160009 LKWASH-SPR,HLCL,STL,METRIC,M 8