Hi, I have the following data set:
(x,y,z could be any number in the following data sets)
(All IPs are in the IPField, separated by blank)
NameField IPField
A 10.x.x.x 10.y.y.y
B 10.x.x.x 10.y.y.y 10.z.z.z
C 10.x.x.x 10.y.y.y 12.z.z.z 13.x.x.x
D 166.z.z.z 166.x.x.x
E 20.y.y.y 35.x.x.x
Only C and E on the above-mentioned list have different first numbers in their data sets. I want to extract C and E from this example.
With that said, the desired output is:
C 10.x.x.x 10.y.y.y 12.z.z.z 13.x.x.x
E 20.y.y.y 35.x.x.x
How do I do that? Thanks!
// NEW UPDATED
Thanks for answering! Sorry for any confusion made.
To make it more clear:
There are several events (results).
Each event has 2 fields: NameField and IPField
NameField has a single value: A or B or C....
Each NameField is linked to an IPField.
An IPField has multiple IP values,separated by blank. Here are 3 examples:
IPField 1: 10.1.1.1 10.2.2.2 10.3.3.3
IPField 2: 10.1.1.1 20.1.1.1 30.1.1.1 10.2.2.2
IPField 3: 50.1.1.1 50.2.2.2
From the 3 examples above, if we check the first field of every ip addresses in every IPfield, we'll get
IPField 1: 10 10 10
IPField 2: 10 20 30 10
IPField 3: 50 50
I want to find events similar to IPField 2, those with different values in IPField. Thanks!
... View more