I need some help with a CSV file and data extraction. I have a CSV file that looks like the following:
Subnet Ipaddress IsInBoth
255.255.255.0 10.1.10.0 10.1.10.0
255.255.252.0 10.3.10.0 10.2.10.0
255.255.255.0 10.4.10.0 10.3.10.0
I need to read the IsInBoth value for each row, compare it to every item of data in the Ipaddress column in the file and if they match extract the Subnet for that row.
Is the above possible?