Hi please can some one with very strong SQL skills in Log Parser help me find a solution to this problem.
I have a text file with data that look like this
Vlan Mac Address Type Protocol Operation Interface
------+-------------------+--------------+-----------+------------+-----------
220 00:1f:29:db:37:af learned 0 bridging 1/2
220 00:22:64:a9:27:bc learned 0 bridging 1/5
220 00:11:43:c2:ef:02 learned 0 bridging 1/6
1 00:20:da:fd:5b:60 learned 10806 bridging 1/7
220 00:0d:56:1e:84:b9 learned 0 bridging 1/7
220 00:13:21:5e:8a:81 learned 0 bridging 1/7
220 00:18:71:6d:09:24 learned 0 bridging 1/7
220 00:19:bb:4d:7f:71 learned 0 bridging 1/7
220 00:19:bb:5f:68:bf learned 0 bridging 1/7
220 00:1a:4b:11:0c:f3 learned 10806 bridging 1/7
220 00:1f:29:1b:db:f9 learned 0 bridging 1/7
220 00:22:64:aa:16:58 learned 0 bridging 1/7
220 00:c0:b7:6c:4f:9e learned 0 bridging 1/7
220 00:50:60:02:cf:f9 learned 10806 bridging 1/8
220 00:60:9f:92:9d:a9 learned 0 bridging 1/8
220 00:c0:b7:cb:0f:2e learned 10806 bridging 1/8
1 00:d0:95:33:44:40 learned 10806 bridging 1/9
1 00:d0:95:53:6c:80 learned 10806 bridging 1/9
204 00:00:74:9b:32:61 learned 0 bridging 1/9
204 00:08:02:5e:12:02 learned 0 bridging 1/9
204 00:13:21:5f:04:d4 learned 0 bridging 1/9
204 00:14:c2:57:b7:d4 learned 0 bridging 1/9
204 00:17:a4:15:c5:d6 learned 0 bridging 1/9
204 00:19:bb:5c:c1:2e learned 0 bridging 1/9
204 00:1e:0b:3f:49:50 learned 0 bridging 1/9
204 00:22:64:a9:28:3e learned 0 bridging 1/9
204 00:d0:95:33:44:43 learned 10806 bridging 1/9
204 00:d0:95:53:6c:83 learned 10806 bridging 1/9
220 00:00:74:a9:87:5a learned 0 bridging 1/9
220 00:19:bb:5f:6a:69 learned 0 bridging 1/9
220 00:1c:c4:63:13:0e learned 0 bridging 1/9
220 00:1c:c4:63:18:d3 learned 0 bridging 1/9
220 00:1c:c4:64:20:b9 learned 0 bridging 1/9
220 00:22:64:a8:6f:1a learned 0 bridging 1/9
220 00:c0:b7:cb:0e:d4 learned 0 bridging 1/9
What I need is LP to interrogate this text file and remove all lines of data where an occurance under the (interface heading) appears more then once.
In other words all lines of data that have 1/7 + 1/8 + 1/9 will be removed